Trying to add a value if a test result is positive or negative
Closed
Choo
-
Jan 15, 2015 at 07:27 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 15, 2015 at 08:30 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jan 15, 2015 at 08:30 AM
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 songs to sound picker - Guide
- How to add @ in laptop - Guide
- Add messenger to home screen - Guide
- How to add a tick in word - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Jan 15, 2015 at 08:30 AM
Jan 15, 2015 at 08:30 AM
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.