B1 is the smaller one, so (B1/A1) = 0.3 (which -IS- 30%)
You can SKIP the "multiply by 100" step, and use
"format --> number --> percent" to have 0.3 displayed as 30%
without turning it into 30.0
*** which is probably more usefull for later calculations ***
However, if you multiply the result by 100, with "=B1/A1*100"
you will get 30, but the % sign will not be shown.
Also, if your A1 & B1 change values, you are going to wind up
with some LONG decimals like .2416666666, so you might want to
limit the number of decimal places displayed.
You would need to decide if you WANT to trim those partial
percentage values (possibly causing rounding errors) or if
you would rather leave the decimal part-values in the number
but just not display them.
If you want to keep the partial decimals, then just change the
formatting, so that the long decimals aren't displayed, but are
still used for calculation...
...or, you can either use the ROUND() or TRUNC() functions to
remove the fractional bits from your values, so that what's
being displayed is exactly what's being used to calculate.
|
