| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The formula to determine if with 3 separate if conditions.
A Sales Rep has a full year target of 300, split into 3 levels - 100, 200 and
300, with a payout of 15%, 20% and 25% at the 3 levels. Need to know the formula that calculates where a YTD performance # is relative to a payout on the 3 levels. For ex. If YTD # is 300 then Level 1 is 100 with a payout at 15%, Level 2 is 100 with a payout of 20% and Level 3 is also 100 paying at 25%. If YTD = 65 then only Level 1 at 15%. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine a result of one column based on conditions in two column | Excel Discussion (Misc queries) | |||
| Simple ? countif, 3 separate conditions across multi tabs | Excel Worksheet Functions | |||
| How to determine the values based on given conditions? | Excel Discussion (Misc queries) | |||
| How to determine the formula? | Excel Discussion (Misc queries) | |||
| Two Separate Conditions for Cond. formatting | Excel Worksheet Functions | |||
Threaded Mode
