Report

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

Ask a question bselby123 1Posts Monday February 22, 2016Registration date February 22, 2016 Last seen - Last answered on Feb 22, 2016 06:28PM
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!
See more 
Helpful
+1
moins plus
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!

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!