if/and statements

B

BobVA

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

aidan.heritage

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

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

Duke Carey

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)
 
D

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?
Click to expand...

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

BobVA

Andy said:
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
Click to expand...
 
Top