Prev: Site for some reason, and forbidden
Next: using a time format in a count function
From: aetejada on 6 May 2010 17:30
okay. So I am trying to workout a formula to compute a commision earning.
Basically, if X amount of new business is made, then X*Y (corresponding
Commision rate percentage), but if new business =<X, then X*Y (Commision rate
percentage that is true).

Problem is, it's super confusing...anyone have any suggestions?
From: T. Valko on 6 May 2010 18:47
See if this helps:

http://mcgimpsey.com/excel/variablerate.html

--
Biff
Microsoft Excel MVP


"aetejada" <aetejada(a)discussions.microsoft.com> wrote in message
news:AA4E55F7-9435-4BB6-837A-416A59BB72A0(a)microsoft.com...
> okay. So I am trying to workout a formula to compute a commision earning.
> Basically, if X amount of new business is made, then X*Y (corresponding
> Commision rate percentage), but if new business =<X, then X*Y (Commision
> rate
> percentage that is true).
>
> Problem is, it's super confusing...anyone have any suggestions?


 | 
Pages: 1
Prev: Site for some reason, and forbidden
Next: using a time format in a count function