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
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 just need to enter the Cell number and no of DP you would like.
i.e =round(A1,1) for 1dp.
Thanks
Gazzr
See
http://www.xldynamic.com/source/xld.Rounding.html
Rounding In Excel
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"harshaputhraya"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
To round a percentage in A1 up to the next 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)
"caryd" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks