formulae

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

I have a field which does calculation on the IF condition, does fine till
have a negative conditon

e.g. =IF(H3<=-4000,"CAMERA",IF(H3<=-8000,"PRINTER"))

now the statement comes in field 'I' e.g. CAMERA etc.

tried having the amount in () still does not show up

also can I have both the + and - conditon in on IF statement

please advise

thanks
 
=IF(H3<=-4000,"CAMERA",IF(H3<=-8000,"PRINTER"))

Assuming you are ahppy with false appearing if the value is not less
than 4000, the first condition will always be met if h3 <=-8000 it will
also be <=-4000 so you will never get "PRINTER" returned

Try switching you conditions

=IF(H3<=-8000,"PRINTER",IF(H3<=-4000,"CAMERA"))

Regards

Dav
 
Try this formula if field "I":
=IF(H3>-4000,"",IF(AND(H3<=-4000,H3>-8000),"CAMERA",IF(H3<=-8000,"PRINTER")))

If H3 is greater than -4000, cell is blank, if H3 is less than or equal to
-4000 AND greater than -8000, cell is CAMERA, if H3 is less than or equal to
-8000, cell is PRINTER.
 
Back
Top