Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
54.52 and I want to know which fuction/formula to use for making these as
88.25, 89.00, 72.40, 54.50. Please help. Thanks.

On Sat, 9 Jan 2010 01:43:23 +0530, "Sandeep Lohchab"
wrote:

Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
54.52 and I want to know which fuction/formula to use for making these as
88.25, 89.00, 72.40, 54.50. Please help. Thanks.



Try this formula:

=MROUND(A1,0.05)

Hope this helps / Lars-Åke

=MROUND(A1,0.05)

If you get a message that the function is not available:
ToolsAdd-insCheck Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sandeep Lohchab" wrote in message
...
Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
54.52 and I want to know which fuction/formula to use for making these as
88.25, 89.00, 72.40, 54.50. Please help. Thanks.

I found it in help. its floor function =FLOOR(C1, 0.05)
one more thing sir, is there any easier formula than this???
=A1/100*B1/100*100+A1
actually i want to know 6% of 100 and also add to it.

thanks in advance.


"Sandeep Lohchab" wrote in message
...
Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
54.52 and I want to know which fuction/formula to use for making these as
88.25, 89.00, 72.40, 54.50. Please help. Thanks.

No, FLOOR(72.39,0.05) will give you 72.35 instead of the 72.40 you
want.

=A1/100*B1/100*100+A1
could be simplified to
=A1*B1/100+A1

Hope this helps / Lars-Åke


On Sat, 9 Jan 2010 02:00:12 +0530, "Sandeep Lohchab"
wrote:

I found it in help. its floor function =FLOOR(C1, 0.05)
one more thing sir, is there any easier formula than this???
=A1/100*B1/100*100+A1
actually i want to know 6% of 100 and also add to it.

thanks in advance.


"Sandeep Lohchab" wrote in message
...
Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
54.52 and I want to know which fuction/formula to use for making these as
88.25, 89.00, 72.40, 54.50. Please help. Thanks.

Hi

With 100 in A1 and 6% in B1
=A1*(1+B1)

--
Regards
Roger Govier

"Sandeep Lohchab" wrote in message
...
I found it in help. its floor function =FLOOR(C1, 0.05)
one more thing sir, is there any easier formula than this???
=A1/100*B1/100*100+A1
actually i want to know 6% of 100 and also add to it.

thanks in advance.


"Sandeep Lohchab" wrote in message
...
Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
54.52 and I want to know which fuction/formula to use for making these as
88.25, 89.00, 72.40, 54.50. Please help. Thanks.




__________ Information from ESET Smart Security, version of virus
signature database 4755 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4755 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com