| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula showing 0 - don't want it displayed
I'm using the following formula to bring data over from one tab to another,
however, if there is nothing in cell B4 on the Status tab its returning a 0 in the cell. I don't want to see anything in the cell. What do I have to do to modify this? Thanks in advance. =IF($B4=Status!$B4,Status!C4,"") I tried this formula, but it also didn't work - still displays 0 =IF(ISERR(IF($B4=Status!$B4,Status!C4,"")),"",IF($ B4=Status!$B4,Status!C4,"")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula displayed, not calculated | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
| formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
| Formula is displayed, not result | Excel Worksheet Functions | |||
Threaded Mode
