if/and statements

[Guest]

Hello,

This group helped me out a bit before and I'm hoping you can now as I'm
almost done. I'm trying to calculate an annual commission that is paid out
quarterly based on year to date performance. Basically if Jan/Feb/March
sales are grater than 50,000 but less than 100,000 then 1/4 of $7,500 is paid
out. I have the following:

=IF(AND(E7+E8+E9)*4>50000,(E7+E8+E9)*4<100000,7500*0.25)

The problem is this formula is generating and answer even though my sales
totals are greater than 100000 when calculated out. Any suggestions?

Thanks.

 

[aidan.heritage]

your brackets in the typed version are wrong
=IF(AND((e7+e8+e9)*4>50000,(e7+e8+e0)*4<100000),7500*.25)

 

[Guest]

Hi

Try this:
=IF(AND((E7+E8+E9)*4>50000,(E7+E8+E9)*4<100000),7500*0.25)

Why are you multiplying the figures by 4? Am I missing something?
Hope this helps.
Andy.

 

[Guest]

You need another couple of parentheses (did not try to test this):

=IF(AND((E7+E8+E9)*4>50000,(E7+E8+E9)*4<100000),7500*0.25)

 

[David Biddulph]

Try this:
=IF(AND((E7+E8+E9)*4>50000,(E7+E8+E9)*4<100000),7500*0.25)

Why are you multiplying the figures by 4? Am I missing something?

My guess is that he is converting the 3-month total to an annual figure?

 

[Guest]

My guess is that he is converting the 3-month total to an annual figure?
--
David Biddulph


Multiplied by 4 to get annual #. Thanks.

 

[Guest]

Hi

Try this:
=IF(AND((E7+E8+E9)*4>50000,(E7+E8+E9)*4<100000),7500*0.25)

Why are you multiplying the figures by 4? Am I missing something?
Hope this helps.
Andy.





Multiplying by 4 to get an annual Number