IF Function

[Jim]

Hi All,
I am trying to work out conditional commissions on sales
targets. I am paying a 2% commission payment on sales
above a certain target figure. Having 2 cells containing
the actual sales and the target sales, say A1 and A2
respectively, I am using the formula:
=IF(A1>A2,A1*2%,0)
Although the function is returning commission payments on
sales above the target figure and giving a 0% amount on
sales less than the target figure the payable amounts are
wrong.
Can anyone help as there is obviously something wrong with
the formula.
Cheers Jim.

 

[RagDyer]

I don't see anything wrong with your formula !
Post back with the actual data that you say is incorrect.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[wwt]

-----Original Message-----
Hi All,
I am trying to work out conditional commissions on sales
targets. I am paying a 2% commission payment on sales
above a certain target figure. Having 2 cells containing
the actual sales and the target sales, say A1 and A2
respectively, I am using the formula:
=IF(A1>A2,A1*2%,0)
Although the function is returning commission payments on
sales above the target figure and giving a 0% amount on
sales less than the target figure the payable amounts are
wrong.
Can anyone help as there is obviously something wrong with
the formula.
Cheers Jim.

.
Jim,

I copied the formula you wrote above to a spread sheet and
it seems to work fine. What is an example response: could
be your cell formatting
Wayne

 

[Jordon]

I am trying to work out conditional commissions on sales
targets. I am paying a 2% commission payment on sales
above a certain target figure. Having 2 cells containing
the actual sales and the target sales, say A1 and A2
respectively, I am using the formula:
=IF(A1>A2,A1*2%,0)
Although the function is returning commission payments on
sales above the target figure and giving a 0% amount on
sales less than the target figure the payable amounts are
wrong.
Can anyone help as there is obviously something wrong with
the formula.

I take it that A1 is actual sales and A2 it the target sales?
Where do payables come in? This formula only calculates
2% of actual sales when they're above the target. Is there
a third cell with a salary?

Jordon

 

[Jim]

-----Original Message-----

I copied the formula you wrote above to a spread sheet and
it seems to work fine. What is an example response: could
be your cell formatting
Wayne

.Thanks for the input Wayne, Seems some figures had been

wrongly processed, and your right the formula is fine.