| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
equaision displaying phantom numbers
You don't want to force it to zero, you want to have it show blank.
=IF(C13="","",((C13-25000)/1000)*5+174) Gord Dibben MS Excel MVP On Fri, 15 Dec 2006 09:05:01 -0800, walt wrote: I have the following equaision that works great but displays a "phantom " number even if the c13 is blank or 0. anyway to force it to 0 untill a number is entered =((C13-25000)/1000)*5+174 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DISPLAYING NUMBERS AS WORDS | Excel Discussion (Misc queries) | |||
| Displaying specific numbers | Excel Discussion (Misc queries) | |||
| displaying numbers in parentheses | Excel Discussion (Misc queries) | |||
| Displaying -ve numbers | Excel Discussion (Misc queries) | |||
| Displaying numbers used in formula | Excel Discussion (Misc queries) | |||
Linear Mode
