| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Want blank cell displayed if indirectly referenced value is zero
Just add it in:
=IF(B4="","",IF(INDIRECT("'"&B$4&"'!$n$44")="","", INDIRECT("'"&B$4&"'!$n$44"))) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Pierre" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Want blank cell displayed if indirectly referenced value is zero
Perhaps one way:
=IF(B4="","",IF(INDIRECT("'"&B$4&"'!$n$44")="","", INDIRECT("'"&B$4&"'!$n$44"))) HTH, Paul -- "Pierre" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Want blank cell displayed if indirectly referenced value is zero
On May 5, 2:37*pm, "PCLIVE" wrote:
Perhaps one way: =IF(B4="","",IF(INDIRECT("'"&B$4&"'!$n$44")="","", INDIRECT("'"&B$4&"'!$n$44*"))) HTH, Paul -- "Pierre" wrote in message ... 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- Hide quoted text - - Show quoted text - Thank you all. Works just fine. Pierre |
| Reply |
| 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) | |||
Linear Mode
