| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Percentage of value
For example
IF i start with 100 i need the next cell below to show what 5% off 100 is. So the answer sould be 5. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Percentage of value
=.05*A1
-- Gary''s Student - gsnu200766 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Percentage of value
"Gary''s Student" wrote: =.05*A1 -- Gary''s Student - gsnu200766 Thanks Although 5% would be 0.05 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Percentage of value
You can also use
=5%*A1 -- Kind regards, Niek Otten Microsoft MVP - Excel "shifty" wrote in message ... | | | "Gary''s Student" wrote: | | =.05*A1 | -- | Gary''s Student - gsnu200766 | | | Thanks | Although 5% would be 0.05 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Percentage of value
Yes, so you can use =5%*A1
-- David Biddulph "shifty" wrote in message ... Thanks Although 5% would be 0.05 "Gary''s Student" wrote: =.05*A1 -- Gary''s Student - gsnu200766 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Percentage of value
"shifty" wrote: For example IF i start with 100 i need the next cell below to show what 5% off 100 is. So the answer sould be 5. Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Percentage of value
I am trying to remember how to figure the percentage of 2 numbers: For
example I have 545 and want to know what percent 379 is of the 545. How would I do that manually and then formulate to excel spread sheet? "shifty" wrote: For example IF i start with 100 i need the next cell below to show what 5% off 100 is. So the answer sould be 5. Thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Percentage of value
Hi
With 545 in A1, and 379 in B1, enter in C1 =B1/A1 Format C1 with FormatCellsNumberPercentage -- Regards Roger Govier "Ball4v" wrote in message ... I am trying to remember how to figure the percentage of 2 numbers: For example I have 545 and want to know what percent 379 is of the 545. How would I do that manually and then formulate to excel spread sheet? "shifty" wrote: For example IF i start with 100 i need the next cell below to show what 5% off 100 is. So the answer sould be 5. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show negative percentage in a fomula? | Excel Discussion (Misc queries) | |||
| show value as percentage in stacked bar graph | Charts and Charting in Excel | |||
| Need to show percentage in a column chart | Charts and Charting in Excel | |||
| How to show negative percentage? | Excel Worksheet Functions | |||
| Show both value and percentage on Waterfall Chart | Charts and Charting in Excel | |||
Linear Mode
