software

I need to create a formula for below:

IF A2 is greater than A1 AND A4gt;A3 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:
gt;
gt; I need to create a formula for below:
gt;
gt; IF A2 is greater than A1 AND A4gt;A3 then A4 should be multiplied by .04,
gt; 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 A2gt;A1 AND A4gt;A3 AND 2 out of the next 3 need to be true A10gt;A9,
A8gt;A7, A6gt;A5 Then A2*.03 or FALSE=IF(AND(A2gt;A1,A4gt;A3,SUM(A10gt;A9,A8gt;A7,A6gt;A5)=2),A2* 0.03)

--
HTH

RP
gt; wrote in message oups.com...
gt; Thanks Dave, wasn't sure if I was in the right forum. I've got another
gt; tough one for you:
gt;
gt; If A2gt;A1 AND A4gt;A3 AND 2 out of the next 3 need to be true A10gt;A9,
gt; A8gt;A7, A6gt;A5 Then A2*.03 or FALSE
gt;
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(A2gt;A1,A4gt;A3,SUM(A10gt;A9,A8gt;A7,A6gt;A5)gt;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
gt; wrote in message oups.com...
gt; Bob, is there a way to fix the formula so if 3 of the 3 are true it
gt; still will compute A2*.3. Right now it only computes if only 2 out of 3
gt; are true. Thanks
gt;
that gt;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(A2gt;A1,A4gt;A3,SUM(A10gt;A9,A8gt;A7,A6gt;A5)gt;=2),A2 *0.03)

--
HTH

RP
gt; wrote in message oups.com...
gt; that gt;2 doesn't seem to work, I checked it but my eyes are going batty,
gt; is that the only thing you changed in the equation?
gt;