How do I fix this formula?
So if which cell is either blank or zero. You are working with 10 cells.
If the cells will either have a number (including zero) or have a blank,
then
Possibly if you mean none of the cells have anything other than blanks or
zero, then
=if(Or(Count(B12:K12)=0,Sum(B12:K12)=0),"",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?
|