Trying to add a value if a test result is positive or negative
Closed
Choo
-
Jan 15, 2015 at 07:27 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 15, 2015 at 08:30 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - 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
- Why can't i add a contact to whatsapp - Guide
- How to add a tick in word - Guide
- How do you add a username or author to a worksheet - Guide
- How to add @ in laptop - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
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.