sclasen0024
New Member
- Joined
- Oct 7, 2015
- Messages
- 6
I need to calculate a bonus paid to a salesperson based upon multiple factors.
IB Pay = hours per demo (f4) then it looks at the pay period (a2) depending on the pay period (due to seasonal volume) would dictate which bonus structure to use see tables below. Once you determine what the payout is for an IB in cell G4 you would take total IB (c4*the payout from tier)
IB Pay = hours per demo (f4) then it looks at the pay period (a2) depending on the pay period (due to seasonal volume) would dictate which bonus structure to use see tables below. Once you determine what the payout is for an IB in cell G4 you would take total IB (c4*the payout from tier)
Last edited:
