All,

I need some quick help. I have a simple forumla and when the number is
negative I need the cell to be 0; however, right now it shows up as
#VALUE!.

Here is the formula:

=IF(G12-40<0,0,G12-40)

Thanks in advance for you help.


--
malakingaso
------------------------------------------------------------------------
malakingaso's Profile: http://www.excelforum.com/member.php...o&userid=31273
View this thread: http://www.excelforum.com/showthread...hreadid=509431