how do i round a quotient to specific decimal places?

  • Thread starter Thread starter gissineth
  • Start date Start date
G

gissineth

i have been trying to find a way to round the value of a quotient to specific
decimal places but I keep getting errors. Is there a way to round quotients
to specific decimal places?
 
i have been trying to find a way to round the value of a quotient to specific
decimal places but I keep getting errors. Is there a way to round quotients
to specific decimal places?
Click to expand...

Use the ROUND function. It's use is well outlined in HELP.

If you are using it, and getting errors, you'll need to post back with some
examples, and information about your errors.
--ron
 
gissineth said:
i have been trying to find a way to round
the value of a quotient to specific decimal
places but I keep getting errors. Is there
a way to round quotients to specific decimal
places?
Click to expand...

It would be helpful if you showed us some examples and explained what the
error is. It might have nothing to do with rounding to a specific number of
decimal places per se.

For example, ROUND(A1/B1,2) rounds to 2 decimal places. But that can result
in an error if B1 is zero. The fix might be IF(B1=0,0,ROUND(A1/B1,2)).

But that is a WAG, due to a dearth of information. There are a myriad of
other possible errors in the data.
 
Suppose A1 hold the numbers 200, then =A1/3 gives 66.666666666...
The formula =ROUND(A1/3,2) will give the result of the division to two
decimal places as in 66.67
However, if the cell is formatted to show more than two decimals you may see
66.6700000
with zeros after the required two decimals.
The answer is still correct to 2 decimals.
If cell A2 has =A1/3 then the formula =A2*3 will give 200
But if A2 as =ROUND(A1/3,2) , then the formula =A2*3 will give 200.01
Does this explain things?
best wishes
 
Back
Top