Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Need help with if/then formulas
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-19-2019, 06:59 AM
p45cal's Avatar
p45cal p45cal is offline Need help with if/then formulas Windows 10 Need help with if/then formulas Office 2016
Expert
  
Join Date: Apr 2014
Posts: 956
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
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas help Grizz1955 Project 0 08-22-2017 05:26 AM
Need help with if/then formulas help with formulas ferrarifx Excel 2 11-16-2016 12:04 PM
Help with IF or ELSE Formulas tsaladyga Excel 4 07-23-2014 09:04 AM
Need help with formulas please paul_pearson Excel 0 03-20-2013 06:51 AM
Need help with if/then formulas IF Formulas mizzamzz Excel 1 07-08-2010 02:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:40 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft