| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying a % as a number
Hi, First post. I have 2009 sales data in column O and 2008 sales data column
P and the the following formula in column Q = O1/P1 as have formatted it as a % to show an increase or decease When the sales data in column o is 0 and p is 0 the result is #DIV/0! When the sales data in column o is 0 and p is 0 the result is a % I want the workbook to display a % when column o is 0 If both 0 & P are 0 i want a 0 to be displayed I appreciate you help Thanks Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying date as a real number | Excel Discussion (Misc queries) | |||
| Displaying a custom formatted number | Excel Discussion (Misc queries) | |||
| Displaying ratio as number of times | Excel Worksheet Functions | |||
| Displaying Last Number that is in a cell | Excel Discussion (Misc queries) | |||
| Displaying decimals that go in to a given number | Excel Discussion (Misc queries) | |||
Threaded Mode
