If statement plus

**morerockin** · 06-23-2018, 07:24 AM

Hello All,

Please see attached.

In column C, I need a formula that looks at column A and does the following:

If column A is wood, it adds 15 work days to the date in column B and puts the result in column C
If column A is steel, it adds 30 work days to the date in column B and puts the result in column C
If column A is wood, it adds 20 work days to the date in column B and puts the result in column C

Thanks

**sandy666** · 06-23-2018, 07:28 AM

Originally Posted by morerockin

If column A is wood, it adds 15 work days to the date in column B and puts the result in column C
If column A is steel, it adds 30 work days to the date in column B and puts the result in column C
If column A is wood, it adds 20 work days to the date in column B and puts the result in column C

which one is correct?

anyway you can try =CHOOSE(MATCH(A2,{"wood","steel","plastic"},0),B2+15,B2+30,B2+20) and format as date
or
=CHOOSE(MATCH(A2,{"wood","steel","plastic"},0),WORKDAY.INTL(B2,15),WORKDAY.INTL(B2,30),WORKDAY.INTL(B2,20))

If statement plus

LinkBack

Thread Tools

Rate This Thread

Display

If statement plus

Re: If statement plus

Thread Information

Users Browsing this Thread

Similar Threads

nested IF statement or AND? trying to write an IF statement with multiple conditions

[SOLVED] If statement to select data - nested statement - assistance

compile error expected line number statement end statement

VBA Compile Error : line number or label or statement or end of statement

[SOLVED] Convert If statement with cell row reference calculations to vlookup statement

VBA- Compile Error, Expected: line number or label or statement or end of statement

[SOLVED] Utilize a Select Case Statement in Target Intersect Statement

Bookmarks

Bookmarks

Posting Permissions