Compute percentage

[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

 

[GS]

A/B*100 and format as percent with no decimals, perhaps!

--
Garry

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

 

[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

No, that didn't work. For example: =(.05/.54)*100 = 9.2593% (not 10%)

 

[GS]

No, that didn't work. For example: =(.05/.54)*100 = 9.2593% (not
10%)

Try wrapping the formula in the ROUND() function.

--
Garry

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

 

[GS]

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