Trying to add a value if a test result is positive or negative
Closed
Choo
-
15 Jan 2015 à 07:27
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 15 Jan 2015 à 08:30
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 15 Jan 2015 à 08:30
Related:
- Trying to add a value if a test result is positive or negative
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add a checkmark in word - Guide
- How to add at the rate in laptop - Guide
- How to add days to a date in excel - Guide
- How to add authorized user t mobile - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Moderator
Last seen
6 September 2024
262
15 Jan 2015 à 08:30
15 Jan 2015 à 08:30
Hello Choo,
I'm assuming that Column A has the drop down, Column B has the test date.
So, in Column C, enter the following formula:-
=IF(A2="Positive",B2+61,IF(A2="Negative",B2+365,""))
and then drag it down as far as you need.
I hope this helps you.
Kind regards,
vcoolio.
I'm assuming that Column A has the drop down, Column B has the test date.
So, in Column C, enter the following formula:-
=IF(A2="Positive",B2+61,IF(A2="Negative",B2+365,""))
and then drag it down as far as you need.
I hope this helps you.
Kind regards,
vcoolio.
