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

"Karen" wrote:

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!