Formula assistance

[Dawn V]

Hello!

I have this formula:
=IF(E18="","",IF(E18="N/A","N/A",IF(E18<=11,"Compliant",IF(E18>=11,"Non Compliant",""))))

*** The problem is if the cell is blank or zero, the equasion equals complaint or non complaint.

Can you reccommend a formula if: E18 is blank or 0, the result should be left blank because I have another formula that is counting the number of items that are compliant or non compliant.

Thanks,
~Dawn

[darkyam]

=IF(OR(E18=0,E18=""),"",IF(E18="N/A","N/A",IF(E18<=11,"Compliant","Non Compliant")))

[Dawn V]

Thank you, Thank you, Thank you!

I don't know what I would do without this forum!