Round off values in Excel
 

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

Round off values in Excel
 

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

Round off values in Excel
 

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

Round off values in Excel
 

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

Round off values in Excel
 

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

Round off values in Excel
 

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

Round off values in Excel
 

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

Round off values in Excel
 

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