Kimber Member Dec 8, 2011 #1 I'm not sure how to phrase my question. I need to have variances show up only as a +/- from "1". In other words, 1.02 should show up as +.02 and .98 should show up as -.02. Your expert help will be greatly appreciated!
I'm not sure how to phrase my question. I need to have variances show up only as a +/- from "1". In other words, 1.02 should show up as +.02 and .98 should show up as -.02. Your expert help will be greatly appreciated!
Luke M Excel Ninja Staff member Dec 8, 2011 #2 Formula to convert number: =A2-1 Custom number format to apply to cell w/ formula: +.00;-.00;.00
Kimber Member Dec 8, 2011 #3 Thank you, Luke! I had the formula correct; however, I didn't format the cell correctly.
