I want to do something that should be very easy, but its not working.
Perhaps you experts can help. =)

I would like to do the following:
IF F5 is greater than 3999 then 10,
IF F5 is less than 2500 then -10,
IF F5 is blank then blank

***A5 is the cell of course***

I've tried these two formulas but they keep coming back with -10 if the
cell is blank.

=IF((F53999),10,IF((F5<2500),-10,IF((F5=""),"","")

and

=IF(F53999),10, IF(F5<2500),-10,IF(F5=""),"","")))

Thank you, thank you, thank you-
Aajaxx


--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: http://www.excelforum.com/member.php...o&userid=31129
View this thread: http://www.excelforum.com/showthread...hreadid=507950