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.

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

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.

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

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

"BobVA" wrote:

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.

<Andy wrote in message ...
"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?

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?

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

"David Biddulph" wrote:

<Andy wrote in message ...
"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?

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?

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


Multiplied by 4 to get annual #. Thanks.

"Andy" wrote:

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.


Multiplying by 4 to get an annual Number