Forum Discussion

Samuel Deane's avatar
Samuel Deane
Copper Contributor
Nov 15, 2018

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 Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi,

     

    Simply, you can achieve this using the IF function as follows:

    =IF(C5="","",C5+1)

     

    Hope that helps

Resources