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
Last edited by rubz71; 11-29-2016 at 12:31 AM.
Like this?
C2 = A2*B2
I would like to display 12.24 if it is +2% or 11.76 if it is -2% in C2Originally Posted by Phuocam
Try ...
=A2*(1+B2)
This will only solve the percentage increase. A2*(1-B2) is for % decrease. Can the cell diferentiate the two formula based on the input?
A2 = 12; B2 = 2% result -> 12.24
A2 = 12; B2 = -2% result -> 11.76
I got you now. works fine. Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks