Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find percentage ???
Er,like =A1*A2 ?????
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email <JoAnne wrote in message ... How do I find percentage of a number... say.. A1 = 100 A2= 60% of A1 (100) Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find percentage ???
Divide 1 Cell by the other and then apply the % format to the cell. Example (without the format % applied 100 75 0.75 with the format % applied 100 75 75.00% then in format set how many decimal places you want. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.hightechtalks.com/m390 View this thread: http://www.hightechtalks.com/t2306229 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
How do I find a percentage? | Excel Discussion (Misc queries) | |||
Percentage Calculation | Excel Worksheet Functions | |||
Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |