Percentages

[Karen]

My question is more on how to display the percentage. I'm calculating
percentages. my formula is G2*J2. My percentage is displaying 1.01 ( which
is 1% increase. I'm trying to format the column, (it's now formated to
general)...if I format to "percentage" format, my column displays 101.00%..
How can I format my cells to display 1% and still maintain my formula of
G2*J2. I've messed with the decimal places, percentage, etc. Not sure what
to do. Probably a very simple question, but I do not use excell very often.
Thanks for your help!

 

[FSt1]

hi
technically 1 is 100%. .01 is 1%. so you will have to change your formula
slightly.
=(G2*J2)*.01
this will yeild .0101. formated to percentage will be 1.01%

Regards
FSt1

 

[JoeU2004]

How can I format my cells to display 1% and still maintain my
formula of G2*J2.

I would prefer to change the formula, namely: =G2*J2/100, formatted as
Percentage. I'm sure it will be less confusing moving forward, especially
if you try to use that "percentage" in other computations.

But if you cannot or will not change the formula, perhaps the following
Custom format will do what you want:

0.00"%";-0.00"%";0.00"%"


----- original message -----