@which function to use when

  • Thread starter Thread starter Sandeep Lohchab
  • Start date Start date
S

Sandeep Lohchab

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.
 
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.
Click to expand...


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:
Tools>Add-ins>Check Analysis Toolpak
 
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.
 
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
 
Hi

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

--
Regards
Roger Govier

Sandeep Lohchab said:
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.






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

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top