#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
In cell C2:
Code:
=IF(OR(B2="ABC",B2="DEF"),A2+45,"") Code:
=IF(B2="DEF",A2+60,"") You may need to format the cells with the formulae in as dates. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formulas help | Grizz1955 | Project | 0 | 08-22-2017 05:26 AM |
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 |
IF Formulas | mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |