incorporate the use of INT (integer)

=IF(AND(INT(C31)=0,C32=0,C33=0),1,"")

=INT(SUM(C31:C32))
--
Don Guillett
SalesAid Software

"soxn4n04" wrote in message
...
That's correct, the cells have formulas in them. Is there a way to write
the
formula to take that into consideration?

"Don Guillett" wrote:

Perhaps your zero is derived from a formula where it does not really =
zero?

--
Don Guillett
SalesAid Software

"soxn4n04" wrote in message
...
I've tried the following formula to get a score of 1 if zero is
entered in
cells 31, 32, 33. This formula does not produce the correct results.
Help!!

=IF(AND(C31=0,C32=0,C33=0),1,"")