Compute percentage

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

I must be brain-dead!

What's the formula that will divide the values in col A by the values in col B and result in 10%?

A B
..05 .54
..12 1.29
..11 1.18
..10 1.07
..09 .96
 
I must be brain-dead! What's the formula that will divide the values in col A by the values in col B and result in 10%? A B .05 .54 .12 1.29 .11 1.18 .10 1.07 .09 .96
Click to expand...



No, that didn't work. For example: =(.05/.54)*100 = 9.2593% (not 10%)
 
Not sure why you want to show *false* values, but using the ROUND()
function will enable you to do so!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top