help creating a formula using IF and AND

J

joe54345

I need to create a formula for below:

IF A2 is greater than A1 AND A4>A3 then A4 should be multiplied by .04,
if A2 is not greater than A1 then A4 should be multiplied by .03.
 
D

Dave Peterson

Check your thread in .misc.

I need to create a formula for below:

IF A2 is greater than A1 AND A4>A3 then A4 should be multiplied by .04,
if A2 is not greater than A1 then A4 should be multiplied by .03.
Click to expand...
 
J

joe54345

Thanks Dave, wasn't sure if I was in the right forum. I've got another
tough one for you:

If A2>A1 AND A4>A3 AND 2 out of the next 3 need to be true A10>A9,
A8>A7, A6>A5 Then A2*.03 or FALSE
 
J

joe54345

thanks Bob!

one more question, how do I move one formula from A1 to e1 without
dragging it over the formulas between?
 
J

joe54345

Bob, is there a way to fix the formula so if 3 of the 3 are true it
still will compute A2*.3. Right now it only computes if only 2 out of 3
are true. Thanks
 
B

Bob Phillips

=IF(AND(A2>A1,A4>A3,SUM(A10>A9,A8>A7,A6>A5)>2),A2*0.03)

will work for 2 and for 3.

If you want to copy to E1, just copy that cell, then paste in E1, Excel will
adjust the formulae.
 
J

joe54345

that >2 doesn't seem to work, I checked it but my eyes are going batty,
is that the only thing you changed in the equation?
 
B

Bob Phillips

Sorry, my bad. I meant

=IF(AND(A2>A1,A4>A3,SUM(A10>A9,A8>A7,A6>A5)>=2),A2*0.03)
 
Top