Hi Guys,
Need help with percentage change formula in Column B.
Ideally, I would like to input 2% on B2 and 2% of 12 (A2) will be displayed in cell C2
The catch is, I would also like to have an option to enter -2% on B2 and C2 will display -2% of 12(A2)
I would like to display 12.24 if it is +2% or 11.76 if it is -2% in C2
Thanks in advance.
A B C
12
14
17
20
Bookmarks