IFS with addition? Help Please

aaronf15

New Member
Joined
Oct 2, 2018
Messages
4
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. Mobile
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!!
 

Attachments

  • EXCEL CAPTURE.JPG
    EXCEL CAPTURE.JPG
    69.3 KB · Views: 9

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

CSmith

Well-known Member
Joined
Jan 13, 2020
Messages
686
Office Version
  1. 365
  2. 2010
  3. 2007
Platform
  1. Windows
  2. Mobile
  3. Web
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

New Member
Joined
Oct 2, 2018
Messages
4
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. Mobile
if the answer is yes then i would like the data from f3 to be entered into h3
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
13,150
Office Version
  1. 365
Platform
  1. Windows
Try

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

Forum statistics

Threads
1,136,324
Messages
5,675,096
Members
419,549
Latest member
EliteBeat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top