MS Excel Nested IF Statement for multiple variables within a column

Need help in creating a NESTED IF statement is needed to add 30/30/90 Days to the date automatically on top of the "Status Date" when the corresponding status is selected.  

For example: If "Status" = Status 9 + 30 Days; Due Date = Status Date + 30 Days --

I was able to create an if Statement for 30 Days report, but not sure about how to the the nested statment.

=IF(F3="Status 9 + 30 Days",G3+30)

This thread is directed towards fixes for issue 5b.  A description of the issues are also located on the Desc tab of the workbook. Issues 6-11  will be following in subsequent posts.

Thank you in advance for your assistance.
Test-Report-v2.xlsm
ckwillGWUAsked:
Who is Participating?
 
dlmilleConnect With a Mentor Commented:
We can use a vlookup table - adding data to the right of your drop down range, a range called StatusDaysAdvance which incorporates Status 9+30, etc.  We can then use the results of that vlookup to add to the status date as follows:

put this in cell H2 and copy down:

[H2]=IF(UPPER(LEFT(F2,6)) = "STATUS",IFERROR(VLOOKUP(F2,StatusDaysAdvanced,3,0),0)+G2,"")

See attached.

Cheers,

Dave
Test-Report-v3.xlsm
0
 
ckwillGWUAuthor Commented:
Thanks Dave, the solution worked very well, although, I'm not 100% on how it works exactly, but I will do my best to disect this later. Thanks again.

-- Chris
0
 
ckwillGWUAuthor Commented:
Excellent method.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.