If Statement

[helpme290]

Need help with if statements. See attached for the spreadsheet.

[TABLE="width: 574"]
<colgroup><col><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD="colspan: 5"]What I am trying to do all within Column G is;[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"]1) IF Column F is empty take date from Column E - see formula above [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 5"]2) If column B says "No", column G date +5 days,[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"]3) If column B is "yes" and Column C says "no" I want Column G +45 days[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"]4) If Column B and G both say "yes" Column G + 75 Days[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

As you have discovered, you cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: Guidelines for Forum Use.

Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

Also, it would be helpful if you placed your conditions in the order that you need them evaluated. For example, #4 needs to happen before 3 (or else it will never get to 4 because 3 will be met before 4 will). The big question is should #1 be checked first or last?

 

[micsza]

I assume that: 1) if F is not empty, then it shows the "base date" we take for G; 2) in your #4 point there is a typo: it's C not G we test. If so, pls try this:

=IF(F1="",E1,F1)+IF(B1="No",5,IF(C1="No",45,75))

 

[helpme290]

Thanks for the reply, I have posted a table below.


The Order that is should Happen is
1)F Column F is empty take date from Column E
2)IF column B says "No", column G date +5 days,
3) IF Column B is "yes" and Column C says "no" I want Column G +45 days
4)If Column B and G both say "yes" Column G + 75 Days

[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]B
[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]New product[/TD]
[TD]FDA Check[/TD]
[TD]Year[/TD]
[TD]Planned[/TD]
[TD]Actioned[/TD]
[TD]Arrived[/TD]
[/TR]
[TR]
[TD]No[/TD]
[TD]No[/TD]
[TD]2017[/TD]
[TD]8/15/2017[/TD]
[TD][/TD]
[TD]8/20/17[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]no[/TD]
[TD]2017[/TD]
[TD]8/1/2017[/TD]
[TD]7/19/207[/TD]
[TD]7/24/2017[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]yes[/TD]
[TD]2017[/TD]
[TD]12/1/2017[/TD]
[TD][/TD]
[TD]12/6/2017[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[helpme290]

Micsza - works like a charm thanks for the speedy reply!

 

[micsza]

You are welcome!