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.

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

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

=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

thanks Bob!

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

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

=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