in [Functions]

Prev: Thanks
Next: Excel 2007: Vlookup Problem
From: Sandeep Lohchab on 8 Jan 2010 15:13 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.
From: Lars-�ke Aspelin on 8 Jan 2010 15:21 On Sat, 9 Jan 2010 01:43:23 +0530, "Sandeep Lohchab" <sandeeplohchab (a)yahoo.com> 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
From: Niek Otten on 8 Jan 2010 15:26 =MROUND(A1,0.05) If you get a message that the function is not available: Tools>Add-ins>Check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "Sandeep Lohchab" <sandeeplohchab (a)yahoo.com> wrote in message news:u7o6J8JkKHA.1536 (a)TK2MSFTNGP06.phx.gbl...> 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. >
From: Sandeep Lohchab on 8 Jan 2010 15:30 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" <sandeeplohchab (a)yahoo.com> wrote in message news:u7o6J8JkKHA.1536 (a)TK2MSFTNGP06.phx.gbl...> 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. >
From: Lars-�ke Aspelin on 8 Jan 2010 15:50
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" <sandeeplohchab (a)yahoo.com> 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" <sandeeplohchab (a)yahoo.com> wrote in message >news:u7o6J8JkKHA.1536 (a)TK2MSFTNGP06.phx.gbl...>> 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. >> > |