software

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: www.excelforum.com/member.php...oamp;userid=33225
View this thread: 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: www.excelforum.com/member.php...oamp;userid=31075
View this thread: www.excelforum.com/showthread...hreadid=539161
See

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;harshaputhrayaquot;
lt;harshaputhraya.27biha_1146804601.3144@excelforu m-nospam.comgt; wrote in
message news:harshaputhraya.27biha_1146804601.3144@excelfo rum-nospam.com...
gt;
gt; Hi,
gt; I have some values with decimal points...eg 2.4356
gt; I want to round them to the nearest value with one decimal place (say
gt; 2.4 in this case) for some calculation purpose.
gt; How can i achieve in Excel 2003?
gt;
gt; Appreciate your help
gt;
gt; Regards,
gt; Harsha
gt;
gt;
gt; --
gt; harshaputhraya
gt; ------------------------------------------------------------------------
gt; harshaputhraya's Profile:
www.excelforum.com/member.php...oamp;userid=33225
gt; View this thread: www.excelforum.com/showthread...hreadid=539161
gt;

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: www.excelforum.com/member.php...oamp;userid=34433
View this thread: 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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: 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: www.excelforum.com/member.php...oamp;userid=34433
View this thread: www.excelforum.com/showthread...hreadid=539161He 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)

quot;carydquot; gt; wrote in
message ...
gt;
gt; I am diriving the value of the cell from a formula and I'm not sure what
gt; to replace. Can you explain what I need to do?
gt;
gt;
gt; --
gt; caryd
gt; ------------------------------------------------------------------------
gt; caryd's Profile:
www.excelforum.com/member.php...oamp;userid=34433
gt; View this thread: www.excelforum.com/showthread...hreadid=539161
gt;

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: www.excelforum.com/member.php...oamp;userid=34433
View this thread: www.excelforum.com/showthread...hreadid=539161