Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

If/then formula in Excel [Closed]

Report
Posts
1
Registration date
Thursday December 13, 2018
Status
Member
Last seen
December 13, 2018
 -
Posts
2621
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 28, 2020
 -
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
See more

1 reply

Answer 1 / 1
Posts
2621
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 28, 2020
 421
Hi Melkeenan13,

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

Best regards,
Trowa
Ask a question