Thread: Need help with if/then formulas
View Single Post
 
Old 04-19-2019, 06:59 AM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
In cell C2:
Code:
=IF(OR(B2="ABC",B2="DEF"),A2+45,"")
In cell D2:
Code:
=IF(B2="DEF",A2+60,"")
copy C2:D2 down.
You may need to format the cells with the formulae in as dates.
Reply With Quote