ExcelBanter - how to get the percentage symbol with the result?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to get the percentage symbol with the result? (https://www.excelbanter.com/excel-discussion-misc-queries/448516-how-get-percentage-symbol-result.html)

sumesh56

how to get the percentage symbol with the result?

GS[_2_]

how to get the percentage symbol with the result?

how to get the percentage symbol with the result?
i have a farmula to calculate the percentage. i want to get the
result with the percentage sign.It should be something like this.
D2=540 E2=600
F2=PERCENTAGE(D2/E2*100)%
thanks.

Format F2 in the % style;
Change your formula to...

=D2/E2

...and that's it!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Spencer101

Quote:

Originally Posted by sumesh56 (Post 1610794)

The formula in F2 only has to be =D2/E2 and the cell formatted as percentage.

sumesh56

Quote:

Originally Posted by Spencer101 (Post 1610798)

The formula in F2 only has to be =D2/E2 and the cell formatted as percentage.

thanks all for the replies.

CellShocked

how to get the percentage symbol with the result?

On Mon, 1 Apr 2013 07:15:09 +0000, Spencer101
wrote:

sumesh56;1610794 Wrote:
how to get the percentage symbol with the result?
i have a farmula to calculate the percentage. i want to get the result
with the percentage sign.It should be something like this.
D2=540 E2=600
F2=PERCENTAGE(D2/E2*100)%
thanks.

The formula in F2 only has to be =D2/E2 and the cell formatted as
percentage.

Format the cell as custom, and enter something like

## %

OR

##.# %

The space and the percent sign are TEXTUAL additions ('concatenations')
after the value gets the #.## or whatever formatting.

All times are GMT +1. The time now is 02:58 AM.