easy formula

  • Thread starter Thread starter smitty
  • Start date Start date
S

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.
 
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.
 
Back
Top