Or, if your functions return valid data < 0:


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

where n is the number of decimal places to round to to get the required
granularity (n = 1 to 15)




In article ,
"Don Guillett" wrote:

incorporate the use of INT (integer)

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