HighlandPiper
New Member
- Joined
- Apr 28, 2016
- Messages
- 19
Hi all
I am working on a spreadsheet with formulae. I am trying to hide a date in one cell when N/A is displayed in another. The cell I am trying to hide already has a formula in it and I suppose I need to had some form of nested IF statement. I have no idea how to do this.
The fomula in the cell below 'Practical Period Start Date' is: =IF('#FORMAT SHEET'!Z4="","",'#FORMAT SHEET'!Z4). I need to keep this formula, but is there anyway I can add to the existing formula to hide the content of this cell, or change it to 'N/A' when the 'Aim Type 5' is 'N/A'. Once I have a solution I will need to replicate the formula to a number of other cells, which I will be able to manage.
Any help would be appreciated.
Highlander
I am working on a spreadsheet with formulae. I am trying to hide a date in one cell when N/A is displayed in another. The cell I am trying to hide already has a formula in it and I suppose I need to had some form of nested IF statement. I have no idea how to do this.
The fomula in the cell below 'Practical Period Start Date' is: =IF('#FORMAT SHEET'!Z4="","",'#FORMAT SHEET'!Z4). I need to keep this formula, but is there anyway I can add to the existing formula to hide the content of this cell, or change it to 'N/A' when the 'Aim Type 5' is 'N/A'. Once I have a solution I will need to replicate the formula to a number of other cells, which I will be able to manage.
Any help would be appreciated.
Highlander