| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested Formula Help
I am trying to write a formula that will take the total contract value
and times it by the assoicated percentage. $1-$4,999,999 = 5% $5,000,000 - $9,999,999 = 10% $10,000,000+ = 15% If the contract value is $6,000,000, than it would do ($4,999,999*5%)+ ($1,000,001*10%)=$350,000.05 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Regarding NESTED IF formula | Excel Discussion (Misc queries) | |||
| Help again on an if nested formula | Excel Discussion (Misc queries) | |||
| Help with formula too many nested IFs | Excel Worksheet Functions | |||
| Nested Formula? | Excel Worksheet Functions | |||
| Nested Formula | Excel Worksheet Functions | |||
Threaded Mode
