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.
|