You could do it by adding a couple ANDs along with more ORs but YIKES!
Use an array formula (i.e. use shift-ctrl-enter after you type it):
=IF(SUM((B12:K12<=3)+(B12:K12=0)+ISBLANK(B12:K12)) 0,"Please enter your
remarks...","")
Explanation:
This makes three arrays for your 3 conditions: any one that is true gives a
1 in that position (otherwise 0, numeric equivalents of true/false). Add
them together element by element to combine the results and if none are true
you have all zeros - anything else means at least one condition violated.
Now add the elements together and get the overall result: again, if any
condition was not true you will get something other than zero.
--
- K Dales


"Darren" wrote:

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?