How do I fix this formula?
Another possibility is that you don't want to show a message unless all
cells contain a value greater than 0 and are not blank
=If(countif(B12:K12,"0")<10,"",current formula)
--
Regards,
Tom Ogilvy
"Darren" wrote in message
...
How do I fix this formula
"=IF(OR(B12<=3,C12<=3,D12<=3,E12<=3,F12<=3,G12<=3, H12<=3,I12<=3,J12<=3,K12<=
3),"Please
enter your remarks for 3's and less","")" so if the cell is either blank
or
"0", then neither of the remarks will appear?
|