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


--
harshaputhraya
------------------------------------------------------------------------
harshaputhraya's Profile: http://www.excelforum.com/member.php...o&userid=33225
View this thread: http://www.excelforum.com/showthread...hreadid=539161

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

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

Thanks
Gazzr


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=539161

See

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"harshaputhraya"
<harshaputhraya.27biha_1146804601.3144@excelforu m-nospam.com wrote in
message news:harshaputhraya.27biha_1146804601.3144@excelfo rum-nospam.com...

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


--
harshaputhraya
------------------------------------------------------------------------
harshaputhraya's Profile:
http://www.excelforum.com/member.php...o&userid=33225
View this thread: http://www.excelforum.com/showthread...hreadid=539161

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


--
caryd
------------------------------------------------------------------------
caryd's Profile: http://www.excelforum.com/member.php...o&userid=34433
View this thread: http://www.excelforum.com/showthread...hreadid=539161

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=539161

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?


--
caryd
------------------------------------------------------------------------
caryd's Profile: http://www.excelforum.com/member.php...o&userid=34433
View this thread: http://www.excelforum.com/showthread...hreadid=539161

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" wrote in
message ...

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?


--
caryd
------------------------------------------------------------------------
caryd's Profile:
http://www.excelforum.com/member.php...o&userid=34433
View this thread: http://www.excelforum.com/showthread...hreadid=539161

I fugured out what you meant by replacing A1 with the formula. Now it
reads: =CEILING(T2+U2,1/800)

Thank you for your assistance.


--
caryd
------------------------------------------------------------------------
caryd's Profile: http://www.excelforum.com/member.php...o&userid=34433
View this thread: http://www.excelforum.com/showthread...hreadid=539161