| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating correct pecentages with negative values
I need a formula that will return the correct percentage where there is 4
scenarios of comparing Actuals as a percentage of Plan. eg Actual Plan 110 100 90 100 -10 100 -90 -100 -110 -100 50 -100 10 0 -10 0 I have tried several formulas but they do return the correct answer in all cases. Any suggestions would be appreciated. Many Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| negative values | Excel Discussion (Misc queries) | |||
| show difference between weights with correct pos and neg values | Excel Worksheet Functions | |||
| how do i hide negative values in excel | Excel Discussion (Misc queries) | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| calculating positive and negative formulas | Excel Worksheet Functions | |||
Threaded Mode
