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 adj...
Haytham Amairah
Nov 15, 2018Silver Contributor
Hi,
Simply, you can achieve this using the IF function as follows:
=IF(C5="","",C5+1)
Hope that helps
- Samuel DeaneNov 15, 2018Copper ContributorPerfect, works well. Thanks!