I'm using a formula to show the year to year (YTY) change in points.
Col CX = 50% Col CV = 45%
Using the formula above, the answer is -5%. I'd like to change this formula so it automatically will say -5 pts, meaning there was a -5 pt shift YTY instead of saying its -5%. Can anyone help me make this change?=IF(ISERROR(+CX9-CV9),"-",+CX9-CV9)
Thank you very much.
Bookmarks