help creating a formula using IF and AND
 

I need to create a formula for below:

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

help creating a formula using IF and AND
 

Check your thread in .misc.

wrote:

I need to create a formula for below:

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

--

Dave Peterson

help creating a formula using IF and AND
 

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

If A2A1 AND A4A3 AND 2 out of the next 3 need to be true A10A9,
A8A7, A6A5 Then A2*.03 or FALSE

help creating a formula using IF and AND
 

=IF(AND(A2A1,A4A3,SUM(A10A9,A8A7,A6A5)=2),A2* 0.03)

--
HTH

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

If A2A1 AND A4A3 AND 2 out of the next 3 need to be true A10A9,
A8A7, A6A5 Then A2*.03 or FALSE

help creating a formula using IF and AND
 

thanks Bob!

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

help creating a formula using IF and AND
 

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

help creating a formula using IF and AND
 

=IF(AND(A2A1,A4A3,SUM(A10A9,A8A7,A6A5)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.

--
HTH

RP
wrote in message
oups.com...
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

help creating a formula using IF and AND
 

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?

help creating a formula using IF and AND
 

Sorry, my bad. I meant

=IF(AND(A2A1,A4A3,SUM(A10A9,A8A7,A6A5)=2),A2 *0.03)

--
HTH

RP
wrote in message
oups.com...
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?