Round off values in Excel

  • Thread starter Thread starter harshaputhraya
  • Start date Start date
H

harshaputhraya

Hi,
I have some values with decimal points...eg 2.4356
I want to round them to the nearest value with one decimal place (say
2.4 in this case) for some calculation purpose.
How can i achieve in Excel 2003?

Appreciate your help:)

Regards,
Harsha
 
You can use ither ROUND() ROUNDUP() or ROUNDDOWN() functions. You jus
need to enter the Cell number and no of DP you would like.

i.e =round(A1,1) for 1dp.

Thanks
Gazz
 
Rounding up to the nearest 1/8

Along the same lines as the initial question I need for 3 columns on my
spreadsheet to round up to the nearest .125 of a percent

This is for mortgage financing purposes and I haven't been able to
acheive this. Any help would greatly be appreciated...

Thanks
Cary D
 
To round a percentage in A1 to the nearest 1/8 of a percent

=CEILING(A1,1/800)

or if you're deriving the value in A1 from a formula just replace A1
with your formula in the above
 
I am diriving the value of the cell from a formula and I'm not sure what
to replace. Can you explain what I need to do?
 
He means to replace the A1 in =CEILING(A1,1/800) with whatever formula is in
A1.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
I fugured out what you meant by replacing A1 with the formula. Now i
reads: =CEILING(T2+U2,1/800)

Thank you for your assistance
 
Back
Top