Round off values in Excel

[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

 

[Gazzr]

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

 

[Bob Phillips]

See

http://www.xldynamic.com/source/xld.Rounding.html
Rounding In Excel

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"harshaputhraya"

 

[caryd]

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

 

[daddylonglegs]

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

 

[caryd]

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?

 

[Bob Phillips]

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)

 

[caryd]

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