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 - Latest answer 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!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!