Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find a percentage?
I'm trying to find a formula that will show 10% of another cell (or group of
cells). If a cell or group of cells adds up to 100, what is the formula that will tell me that 10% of that is 10? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find a percentage?
Hi, Try: =A1*10/100 or =SUM(A1:A10)*10/100 HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=488508 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find a percentage?
"PBarton" wrote:
I'm trying to find a formula that will show 10% of another cell (or group of cells). If a cell or group of cells adds up to 100, what is the formula that will tell me that 10% of that is 10? If A1 is the cell with 100 (or whatever value), arguably the most readable formula is: =A1*10% Of course, you could also write: =A1*0.10 I cannot think of a good reason to write it any differently. "Things should be as simple as possible, but no simpler" -- Einstein. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage Calculation | Excel Worksheet Functions | |||
Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
What function would let me find Batting Averages? | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |