View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default What is wrong with this formula?

this would evaluate to false if any entry in b3:k3 <=3

=IF(OR(B3<=3,C3<=3,D3<=3,E3<=3,F3<=3,G3<=3,H3<=3,I 3<=3,J3<=3,K3<=3),"Please
enter the reason for 3's and less","Thank You")

--


Gary


"Darren" wrote in message
...
=IF(B3:K3<=3,"Please enter the reason for 3's and less","Thank You") The
cells B3 through K3 are valid cells.