Christine,

If your formula has the value zero in quotes

=IF(C3="0",....)

and C3 has numeric data, it will always be false and return the
calculation for the false return. Try taking your qotation marks out
of the formula so

=IF(C3=0,....)

The quotation marks make excel look for a text value not a numeric
value.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=493465