IFS with addition? Help Please

[aaronf15]

I am looking for a formula that will add 180 days to G3 if the answer to E3 is NO with the result put in H3, if the answer is yes put the date in F3 with the result put in H3. I have uploaded a screen shot for reference. Thank you for your help!!

 

[CSmith]

AFAIK, a formula cannot be used that way. What I think is VBA script tied to worksheet change event would work... Clarify the alternative to "NO" please as what you wrote is difficult to discern what expected result you are after...

 

[aaronf15]

if the answer is yes then i would like the data from f3 to be entered into h3

 

[jasonb75]

Try

=IF(E3="NO",G3+180,IF(E3="YES",F3+180,""))

 

[aaronf15]

Try

=IF(E3="NO",G3+180,IF(E3="YES",F3+180,""))

AWESOME THANK YOU!!