Sign + or - percentage Excel (growth calculation)
Solved
ZMEX
Posted messages
51
Status
Membre
-
fredoalex -
fredoalex -
Hello everyone,
I have a bit of a silly question, but I'm going through a thousand paths to solve it.
Here it is: I want to calculate growth over two years. If the result is positive, it should show the result with a small "+" before it. The minus sign is added automatically when checking percentage in cell format.
I'm unable to display the "+"
Yet, I can set colors using conditional formatting (but that's not what I want).
By using the IF formula =IF(C2>0,"+"&C2,C2), it doesn't show percentages when positive, and you can't limit the number of decimal places either.
NB: =(B2-A2)/A2
Would it be possible to put the entire formula in the same cell, like
=IF((B2-A2/A2)%>0,"+"&(B2-A2/A2),(B2-A2/A2))
Assumption: A2=100 and B2=50. It also needs to test the reverse.
Thank you in advance for your help.
I have a bit of a silly question, but I'm going through a thousand paths to solve it.
Here it is: I want to calculate growth over two years. If the result is positive, it should show the result with a small "+" before it. The minus sign is added automatically when checking percentage in cell format.
I'm unable to display the "+"
Yet, I can set colors using conditional formatting (but that's not what I want).
By using the IF formula =IF(C2>0,"+"&C2,C2), it doesn't show percentages when positive, and you can't limit the number of decimal places either.
NB: =(B2-A2)/A2
Would it be possible to put the entire formula in the same cell, like
=IF((B2-A2/A2)%>0,"+"&(B2-A2/A2),(B2-A2/A2))
Assumption: A2=100 and B2=50. It also needs to test the reverse.
Thank you in advance for your help.
Configuration: Windows XP Internet Explorer 6.0
