Home |
Search |
Today's Posts |
#1
|
|||
|
|||
getting a percentage
I want to convert a test score to a percentage, however the fraction may
change e.g. column E displays scores which are out of 14. How do I have that displayed in column F as a percentage? |
#2
|
|||
|
|||
Go to, for example, F1, and enter =E1/14
Then format it as a percentage (click on the % sign on the toolbar, if it's there, if not right click and select format cells then percentage). "Mikewoodmsw" wrote in message ... I want to convert a test score to a percentage, however the fraction may change e.g. column E displays scores which are out of 14. How do I have that displayed in column F as a percentage? |
#3
|
|||
|
|||
\thank you Dave
"Dave R." wrote: Go to, for example, F1, and enter =E1/14 Then format it as a percentage (click on the % sign on the toolbar, if it's there, if not right click and select format cells then percentage). "Mikewoodmsw" wrote in message ... I want to convert a test score to a percentage, however the fraction may change e.g. column E displays scores which are out of 14. How do I have that displayed in column F as a percentage? |
#4
|
|||
|
|||
Mike
In F1 enter =E1/14 and format as percentage. If the 14 will change over time, you could enter that number in a cell(say A1) and refer to the cell. =E1/A1 Gord Dibben Excel MVP On Fri, 21 Jan 2005 15:45:02 -0800, "Mikewoodmsw" wrote: I want to convert a test score to a percentage, however the fraction may change e.g. column E displays scores which are out of 14. How do I have that displayed in column F as a percentage? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percentage of sales | Excel Worksheet Functions | |||
changing the value of each cell in a range by a certain percentage | Excel Discussion (Misc queries) | |||
calculate percentage of two cells | Excel Worksheet Functions | |||
Return A, B, C, or D depending on percentage | Excel Worksheet Functions | |||
percentage of growth | Excel Worksheet Functions |