Thread
:
Getting 0 to equal 1
View Single Post
#
3
Don Guillett
Posts: n/a
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,"")
Reply With Quote