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
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?!


Related:

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
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.
0