easy formula

[smitty]

I am using the following formula...
=if(and(a1<b1,a2<b1,a3<b1,C2>b1),D1,"")

I want a1,a2 and a3 all to be less than b1 and c2>b1 in
order to print D1. The problem here is that if a1 or a2
or a3 is less than b1 it is printing D1. Thanks for your
help.

 

[Andy B]

Hi

Try this:
=IF(AND(AND(A1<B1,A2<B1,A3<B1),C2>B1),D1,"")

 

[JE McGimpsey]

Check that none of your values are actually entered as text. One way:
Select an empty cell. Copy it. Select A1:A3,B1 and C2. Choose Edit/Paste
Special selecting the Add and Values radio buttons.