Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
The formula in F2 only has to be =D2/E2 and the cell formatted as percentage. |
#4
|
|||
|
|||
thanks all for the replies.
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add "+" plus symbol to positive percentage | Excel Discussion (Misc queries) | |||
how to change percentage symbol (Excel XP) | Excel Discussion (Misc queries) | |||
use a symbol as the result of a IF formula | Excel Discussion (Misc queries) | |||
remove percent symbol on percentage formatted cells in excel | Excel Discussion (Misc queries) | |||
how do I assign a symbol to the result of a part of a nested IF s. | Excel Worksheet Functions |