Help with IF STATEMENT / VLOOKUP (I think)
Solved/Closed
bselby123
Posts
1
Registration date
Monday February 22, 2016
Status
Member
Last seen
February 22, 2016
-
Feb 22, 2016 at 03:52 PM
Blocked Profile - Feb 22, 2016 at 06:28 PM
Blocked Profile - Feb 22, 2016 at 06:28 PM
Related:
- Help with IF STATEMENT / VLOOKUP (I think)
- Fenix internet on bank statement - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Excel if statement - Guide
- Sbi bank statement - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
1 response
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!
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!
