Microsoft Office Forums Need help with if/then formulas

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2019, 02:37 AM
elysse77 elysse77 is offline Need help with if/then formulas Windows 10 Need help with if/then formulas Office 2019
Banned
Need help with if/then formulas
 
Join Date: Apr 2019
Posts: 1
elysse77 is on a distinguished road
Default Need help with if/then formulas

Hello everyone,



I’m a novice at Excel and just recently found out how much easier it is to organize data and have Excel do all the “heavy lifting” for me at work.

What I pretty much want to do is have Excel generate a date after it references two different columns. For example, in one column I have dates, and in the second column I have text.

Column 1 has dates. Column 2 has text. So if I type in a specific text in the second column, I want it to generate the date 45 days from the first column in a third column. A different text would generate 45 days in the third column & 60 days in the fourth column.

Example 1: First column = 1 April 2019 Second column = ABC Third column = 16 May 2019 (automatically generates 45 days from Column 1 by Excel)

Example 2: First column = 1 April 2019 Second column = DEF Third Column = 16 May 2019 (automatically generates 45 days from Column 1 by Excel) Fourth column = 31 May 2019 (also automatically generates 60 days from Column 1 by Excel)

Thank you!
Reply With Quote
  #2  
Old 04-19-2019, 06:59 AM
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: 280
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
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
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 05:03 AM.


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