software

hi,

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

e.g. =IF(H3lt;=-4000,quot;CAMERAquot;,IF(H3lt;=-8000,quot;PRINTERquot;))

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(H3lt;=-4000,quot;CAMERAquot;,IF(H3lt;=-8000,quot;PRINTERquot;))

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

Try switching you conditions

=IF(H3lt;=-8000,quot;PRINTERquot;,IF(H3lt;=-4000,quot;CAMERAquot;))

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=539785Try this formula if field quot;Iquot;:
=IF(H3gt;-4000,quot;quot;,IF(AND(H3lt;=-4000,H3gt;-8000),quot;CAMERAquot;,IF(H3lt;=-8000,quot;PRINTERquot;)))

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.

quot;Geraldquot; wrote:

gt; hi,
gt;
gt; I have a field which does calculation on the IF condition, does fine till
gt; have a negative conditon
gt;
gt; e.g. =IF(H3lt;=-4000,quot;CAMERAquot;,IF(H3lt;=-8000,quot;PRINTERquot;))
gt;
gt; now the statement comes in field 'I' e.g. CAMERA etc.
gt;
gt; tried having the amount in () still does not show up
gt;
gt; also can I have both the and - conditon in on IF statement
gt;
gt; please advise
gt;
gt; thanks
gt;
gt;
gt;