formulae
 

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

formulae
 

=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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=539785

formulae
 

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.

"Gerald" wrote:

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