round off

  • Thread starter Thread starter eat77
  • Start date Start date
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
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
What rule are you using that makes the first number round to a whole number
but not the second number?

Rick
 
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.
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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)
 
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.
 
Back
Top