| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Want blank cell displayed if indirectly referenced value is zero
Using the following formula. (located in B17)
=IF(B4="","",(INDIRECT("'"&B$4&"'!$n$44"))) My question is: how to return a blank cell in B17, if N44 (on the referenced tab) is a zero? N44 and B17 are both formatted as percentages. B17 needs to stay as an INDIRECT formula. CF somehow misses on this one, and has no effect. ideas? Thanks. Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting Chart X and Y values indirectly | Charts and Charting in Excel | |||
| What is function that evaluates other functions indirectly? | Excel Worksheet Functions | |||
| Excel - How to indirectly access a file whose name is in a cell | Excel Worksheet Functions | |||
| refer indirectly to Name | Excel Worksheet Functions | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
Threaded Mode
