kznmrexcel
Board Regular
- Joined
- Jun 16, 2010
- Messages
- 86
- Office Version
- 2016
- Platform
- MacOS
If I'm using this formula,
=SUM(-C2+D2)
to show change of a list of different blood test results from one year to the next, but certain items tested one year were not tested the next year (or vice versa), there will be no number value to put in C2 or D2, depending on which year is in question.
If C2 = 100 and D2 = 110, the result with my SUM formula would return 10;
if D2 = 90, it would return -10 to indicate that this particular blood test result went down 10 points from the year before.
How can I modify my formula to return blank instead of zero if either C2 or D2 are blank because that particular blood test wasn't conducted in that year?
I appreciate any help.
Thanks!
=SUM(-C2+D2)
to show change of a list of different blood test results from one year to the next, but certain items tested one year were not tested the next year (or vice versa), there will be no number value to put in C2 or D2, depending on which year is in question.
If C2 = 100 and D2 = 110, the result with my SUM formula would return 10;
if D2 = 90, it would return -10 to indicate that this particular blood test result went down 10 points from the year before.
How can I modify my formula to return blank instead of zero if either C2 or D2 are blank because that particular blood test wasn't conducted in that year?
I appreciate any help.
Thanks!