IF Formula

Jodie

New member
Joined
Jan 20, 2022
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2016
I’m looking for help with a formula that will only do calculation based on if there is data in a cell. Example: ColumnA is an enrollment date but is only used if position is filled. ColumnB is a date 10 years after enrollment date. Can I do a formula that only happens if column A has been populated and leave blank if not? (I don’t want it to come up as false).This type of formula I will hopefully manipulate for other columns as needed.Thanks,Jodie
 
Yeah, you specify "" for false condition, e.g.

=IF(A2<>"",DATE(YEAR(A2)+10,MONTH(A2),DAY(A2)),"")
 
Back
Top