View Single Post
  #5   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?

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?