round off

E

eat77

I'am new in excel, can anyone help on this formula ex: 43.78 must be 44 and
23.41 must be 23.4

Thanks in advance,
eat77
 
S

Sandy Mann

What are the rules that you are applying to get 43.78 to Rpund to 44 (ie
rounding to zero decimal places) and 23.41 to Round to 23.4 (ie rounding to
one decimal place)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
R

Rick Rothstein \(MVP - VB\)

What rule are you using that makes the first number round to a whole number
but not the second number?

Rick
 
D

Dave

Hi,
Use the ROUND function. If your number is in cell A1, then put this in A2:
=ROUND(A1,2)
The 2 in the formula rounds the number to 2 decimal places.
Change the number to suit.
eg. ROUND(A1,0) rounds to nearest integer.
Regards - Dave.
 
S

Sandy Mann

eat77 said:
I use this rule =ROUND(A1,A2,2) but i cant get the 23.41 rounded to 23.4
Click to expand...

Look up ROUND() in Help. With the formula that you are trying to use XL
will reject it and tell you that you have too many argumants with the 2
highlighted. As others have said, with 23.41 in A1 use:

=ROUND(A1,1)

to round to 23.4 - the 1 at the end is the number of decimalplaces you want.

Going by your original examples whereby you said that you wanted 43.78 to
round to 44 and 23.41 to round to 23.4 then try:

=ROUND(A1,--(MOD(A1,1)<0.5))

But somehow I don't think that that was what you meant.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
K

karlonne santos

round off - eat7
09-Jun-08 04:56:09

I'am new in excel, can anyone help on this formula ex: 43.78 must be 44 and
23.41 must be 23.4

Thanks in advance,
eat77
************************************************
here = put this code in to your work

"=ROUND("table number"[T6], 0)"

ex. =ROUND(A1, 0)
 
B

Bob Phillips

You would have to explain the logic as to why 43.78 rounds to the nearest
digit but 23.41 round to the nearest 1/10th.
 
Top