If/then formula in Excel

Closed
melkeenan13 Posts 1 Registration date Thursday December 13, 2018 Status Member Last seen December 13, 2018 - Updated on Dec 16, 2018 at 06:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Dec 13, 2018 at 11:03 AM
I am trying to write a formula that will add a certain number of days to a date, based upon the written response in another cell
ie: if H5="Admit/5 Day", then use G5(which is a date) and add 13 to it; if H5 say's anything else, then add 14 to G5

1 reply

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Dec 13, 2018 at 11:03 AM
Hi Melkeenan13,

Try this formula:
=IF(H5="Admit/5 Day",G5+13,G5+14)

Best regards,
Trowa
0