Help with IF STATEMENT / VLOOKUP (I think) [Solved/Closed]

Report
Posts
1
Registration date
Monday February 22, 2016
Status
Member
Last seen
February 22, 2016
-
 Blocked Profile -
I work for a planning company where we submit lots of applications to do with housing. Different application types have different lengths until decision and completion so I want something like the following for each row:

If submission date=mmddyy and cell=application type 1 then decision date = 21 days later and completion date = 30 days later.

Assume I need an IF statement and a VLOOKUP but not really sure. Any help would be awesome!

1 reply


Hello,

One can accomplish this with a nested if statement. The syntax for If is as follows:
=IF(logic_test,true, false)

So, with that, we can test for two truths as in:
=IF(cell_value_for_date_inst_blank<>"",if(cell_value_for_app_type=1,cell_value_for_date_inst_blank+21,""),"")

Then, in the Completion date column, you have this:
=IF(cell_value_for_date_inst_blank<>"",cell_value_for_date_inst_blank+30,"")

That should cascade entries based on whether the Cell "cell_value_for_date_inst_blank", having a value!

I hope this has helped. It is the most simplest form and is not pretty by any means!

Have FUN!
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!