IF Function

  • Thread starter Thread starter Jim
  • Start date Start date
J

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.
 
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!
==============================================
 
-----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,
Click to expand...
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
 
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.
Click to expand...

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
 
-----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
Click to expand...
wrongly processed, and your right the formula is fine.
 
Back
Top