data two colums percentage third column

M

mhassall1

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....
 
R

Roger Govier

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
 
M

Max

This is exactly what I typed:
=C2/I2
Click to expand...

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
---
 
Top