| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to show negative percentage?
If I divide two negative numeric cells and put the result into a
percentage cell, it will positive, even if the change is negative. For example: A B 1 -6249 -5810 A1/B1 = 107.56% The change is moving from B to A. That means I should have a negative change. How can I show that? Thanks, Brett |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show negative in cell? | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Show both value and percentage on Waterfall Chart | Charts and Charting in Excel | |||
| How do I show negative number in brackets using excel? | Excel Worksheet Functions | |||
| with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) | |||
Threaded Mode
