Previous Topic Next Topic

If/then formula in Excel

Closed
melkeenan13 Posts 1 Registration date Thursday 13 December 2018 Status Member Last seen 13 December 2018 - 13 Dec 2018 à 09:59
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 13 Dec 2018 à 11:03
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 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
13 Dec 2018 à 11:03
Hi Melkeenan13,

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

Best regards,
Trowa

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses