Forum Discussion
Samuel Deane
Nov 15, 2018Copper Contributor
Use a formula if a cell is not blank, display nothing if a cell is blank
Hi,
I've got a schedule document where the first date for the schedule is entered into cell C5. When the date is entered into C5, the next dates in cell C6 onwards autopopulate.
I can get the adjacent cells, e.g. C6 to be blank if no date is entered in C5, however I cannot get it to do this and then add a formula if it is not blank.
What I want to achieve in C6 is if C5 is blank, then do not display anything, BUT if C5 isn't blank (i.e. a date is in this cell), then apply the formula C5+1.
I've searched all over the net but can't find anything, would someone please be able to help with this?
Thank you.
- Haytham AmairahSilver Contributor
Hi,
Simply, you can achieve this using the IF function as follows:
=IF(C5="","",C5+1)
Hope that helps
- Samuel DeaneCopper ContributorPerfect, works well. Thanks!