Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

A while back I posted up about calculating bonuses based upon a lookup. now, I need to add an additional step. Every once in a while, agents get additional bonuses for sales outside of the normal commission ladder. Here's the layout of the main sheet

A                  B C                D           E
Date1 Date2 Date3 .....
agent ID  Agent Name                    $###       $###      $###

What I wanted to do was add an "Additional Bonus sheet" With a layout like this

A               B         C
agentID   Date    Bonus

Then have a "final bonus screen" with this layout and formula similar to the main sheet

A               B C                                        D        E
Date1                                 Date2  Date3
agentID Agent Name $(sales + add bonus total) ... ....

Note: the agent can have multiple bonuses for the same date on the additional bonus sheet. Where would i start doing something like that? I might figure that out while I'm typing that out (which is probably one of the most useful functions of this list), but right now I'm spinning.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.