Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data two colums percentage third column
I am having a hard time finding a function to calculate the percentage using
column A/column B because it keeps returning the answer in column C as zero. Is this a setting specific to my computer or am I doing something wrong? This is exactly what I typed: =C2/I2 and it returns zero although the answer is obviously not zero but a decimal.... |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data two colums percentage third column
Hi
If you have data in column A that you wish to express as a percentage of the value in column B then the formula in C2 should be =A2/B2*100 or, if C2 had been pre-formatted as Percentage, then =A2/B2 -- Regards Roger Govier "mhassall1" wrote in message ... I am having a hard time finding a function to calculate the percentage using column A/column B because it keeps returning the answer in column C as zero. Is this a setting specific to my computer or am I doing something wrong? This is exactly what I typed: =C2/I2 and it returns zero although the answer is obviously not zero but a decimal.... |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data two colums percentage third column
This is exactly what I typed:
=C2/I2 In which cell did you put the above? It shouldn't be in either C2 or I2. And when you select the formula inside the formula bar, then press F9 to evaluate it, what is the result you see? -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "mhassall1" wrote: I am having a hard time finding a function to calculate the percentage using column A/column B because it keeps returning the answer in column C as zero. Is this a setting specific to my computer or am I doing something wrong? This is exactly what I typed: =C2/I2 and it returns zero although the answer is obviously not zero but a decimal.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I delete all colums to the right of a specific column? | Excel Discussion (Misc queries) | |||
how to leave column 1 and move all other colums up or down rows. | Excel Discussion (Misc queries) | |||
Showing Percentage Value Data Label in a 100% Stacked Column Chart | Charts and Charting in Excel | |||
sperating a column in [x y z] to 3 colums x,y,z | Excel Discussion (Misc queries) | |||
What are colums to the left of Column A for? | Excel Worksheet Functions |