| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
[newbie] formatting
I'm trying to display a blank space (or nothing) when there is no difference
between two cells, as in: =IF(C6-C15=0,"",C6-C15) However, when the answer is 0 (i.e. logical test is true), I am getting: 0.00 under the number format 1.89... under the General Format Any idea what format filter to apply? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell formatting [newbie] | Excel Discussion (Misc queries) | |||
| Real Newbie newbie question | New Users to Excel | |||
| Very very new newbie | New Users to Excel | |||
| Help for a newbie? | Excel Worksheet Functions | |||
| Newbie - needing advice on formatting webform data | Excel Discussion (Misc queries) | |||
Threaded Mode
