Forum Discussion
Solved
Formula to calculate % variance
Good Morning,
It is more a mathematical question than an excel related question but I can't figure it out by my own...
I have 20% in a cell A1, 15% in B1 I want to show the difference between...
Nope, copy/paste like this doesn't work. In custom format box you type #" pp", after that press Ctrl and hit J, release Ctrl and type %
Combination Ctrl+J adds non-printable character which force carriage return into the string. It looks like this
% will be invisible here since it's on another line.
If uncheck Wrap Text in cell formatting you'll % within the line, with Wrap Text it's invisible since on another line within the cell
Another trick if apply Wrap Text to C1 and number format like
#" pp"<Ctrl+J>%
More about that is here https://chandoo.org/wp/2012/01/31/custom-number-formats-multiply-divide-by-any-power-of-10/
Trying this one without success.
Do I have to copy paste the #"pp"<ctrl+J>% in custom format ? If yes I can't make it work ...
Thanks for your help
Nope, copy/paste like this doesn't work. In custom format box you type #" pp", after that press Ctrl and hit J, release Ctrl and type %
Combination Ctrl+J adds non-printable character which force carriage return into the string. It looks like this
% will be invisible here since it's on another line.
If uncheck Wrap Text in cell formatting you'll % within the line, with Wrap Text it's invisible since on another line within the cell
Now it's working! Thanks for taking the time to show me the steps
