help creating a formula using IF and AND

Check your thread in .misc.

joe54345@gmail.com wrote:
>
> 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.

--

Dave Peterson

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

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

--
HTH

RP
<joe54345@gmail.com> wrote in message
news:1137438328.031818.118470@g14g2000cwa.googlegroups.com...
> 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
>

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(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.

--
HTH

RP
<joe54345@gmail.com> wrote in message
news:1137441342.625578.102680@g43g2000cwa.googlegroups.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
>

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?

Sorry, my bad. I meant

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

--
HTH

RP
<joe54345@gmail.com> wrote in message
news:1137445596.186245.276900@g49g2000cwa.googlegroups.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?
>