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
Hello,
I have been asked to build a spreadsheet to calculate patients follow up depending on their blood test result.
I will only know if the result is Positive or Negative, so I have a column with a dropdown option for either of those results. If the result is positive I need the next column to calculate a day 61 days from the original test, if its negative then I need it to give me the date a year from the original test.
Halp anyone?!
I have been asked to build a spreadsheet to calculate patients follow up depending on their blood test result.
I will only know if the result is Positive or Negative, so I have a column with a dropdown option for either of those results. If the result is positive I need the next column to calculate a day 61 days from the original test, if its negative then I need it to give me the date a year from the original test.
Halp anyone?!
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 photo in word resume - 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.
