Hi

Try this:
=IF(AND((E7+E8+E9)*450000,(E7+E8+E9)*4<100000),75 00*0.25)

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


"BobVA" wrote in message
...
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)*450000,(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.