| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Negative %
What formula do I use to show a negative percentage. Example:
Column 1 column 2 column 3 0 5 -% -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200508/1 |
|
#2
|
|||
|
|||
|
if what you want is what percent of column 2 is column 1
=A1/B1 and format column 3 as percent If one is a negative the result will be negative I think what you want is more complex than this but we need more information on what you want to do before we can help you. "Michelle Dean via OfficeKB.com" wrote: What formula do I use to show a negative percentage. Example: Column 1 column 2 column 3 0 5 -% -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200508/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating growth with negative numbers | Excel Worksheet Functions | |||
| Summing negative time | Excel Discussion (Misc queries) | |||
| Bar charts with negative values and label position | Charts and Charting in Excel | |||
| How do i enter negative times in Excel & how can they be 'fiddled. | Excel Discussion (Misc queries) | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Linear Mode
