View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?