Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get a percent in excel. ex 24 out of 32
How can I get a percentage of 24 out of 32 if a1=32 and a2=24?
|
#2
|
|||
|
|||
=A2/A1 formatted as a percentage
or =B2/A2% depending on what you want to see and do with the answer Regards Trevor "snowynoe" wrote in message ... How can I get a percentage of 24 out of 32 if a1=32 and a2=24? |
#3
|
|||
|
|||
The key is to know that percentage is merely a fraction multiplied by 100.
A1*100/A2 (with 24 in A1 and 32 in A2) will work but the magic of Excel to give 75 but you need to recall it is a percent. Actually must percentages are used just a fractions without multiplying by 100. SO =A1/A2 give 0.75 but format is as percent and it displays 75%. Half of something (0.5) is 50% of something. If I want 1/2 of $520 I multiply by 0.5 (or divide by 2); if I want 50% then I should multiply by 50 and divide by 100. Excel makes it easy by displaying 50% but storing 0.5. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "snowynoe" wrote in message ... How can I get a percentage of 24 out of 32 if a1=32 and a2=24? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |