G Guest Jul 20, 2007 #1 there used to be an MROUND function that did this but I don't think excel has it anymore. Any suggestions?
there used to be an MROUND function that did this but I don't think excel has it anymore. Any suggestions?
G Guest Jul 20, 2007 #2 MROUND does still exist, but it is part of the Analysis ToolPak, so that must be installed for it to work. In Excel 2003 or earlier: TOOLS-->OPTIONS-->ADD-INS-->Check "Analysis ToolPak" In Excel 2007: OFFICE Button-->Excel Options-->Add-Ins-->GO Button-->Check "Analysis ToolPak" Also, you may want to take a look at the CEILING and FLOOR functions. HTH, Elkar
MROUND does still exist, but it is part of the Analysis ToolPak, so that must be installed for it to work. In Excel 2003 or earlier: TOOLS-->OPTIONS-->ADD-INS-->Check "Analysis ToolPak" In Excel 2007: OFFICE Button-->Excel Options-->Add-Ins-->GO Button-->Check "Analysis ToolPak" Also, you may want to take a look at the CEILING and FLOOR functions. HTH, Elkar
P Peo Sjoblom Jul 20, 2007 #3 It's still there, however there are other ways, assume A1 holds the value you want to round =ROUND(A1/25,0)*25 will do what you want
It's still there, however there are other ways, assume A1 holds the value you want to round =ROUND(A1/25,0)*25 will do what you want
H Harlan Grove Jul 20, 2007 #4 Peo Sjoblom said: It's still there, however there are other ways, assume A1 holds the value you want to round =ROUND(A1/25,0)*25 will do what you want Click to expand... .... It would if you had remembered the decimal points. Your formula rounds to integer multiples of 25. To round to integer multiples of 0.25, use =ROUND(A1/0.25,0)*0.25 or simplify the arithmetic =ROUND(A1*4,0)/4
Peo Sjoblom said: It's still there, however there are other ways, assume A1 holds the value you want to round =ROUND(A1/25,0)*25 will do what you want Click to expand... .... It would if you had remembered the decimal points. Your formula rounds to integer multiples of 25. To round to integer multiples of 0.25, use =ROUND(A1/0.25,0)*0.25 or simplify the arithmetic =ROUND(A1*4,0)/4
P Peo Sjoblom Jul 20, 2007 #5 Harlan Grove said: ... It would if you had remembered the decimal points. Your formula rounds to integer multiples of 25. To round to integer multiples of 0.25, use =ROUND(A1/0.25,0)*0.25 or simplify the arithmetic =ROUND(A1*4,0)/4 Click to expand... I would have remembered if I had seen them, I just glanced at the subject line and didn't see they were decimals. I see it now that you mentioned it. Peo
Harlan Grove said: ... It would if you had remembered the decimal points. Your formula rounds to integer multiples of 25. To round to integer multiples of 0.25, use =ROUND(A1/0.25,0)*0.25 or simplify the arithmetic =ROUND(A1*4,0)/4 Click to expand... I would have remembered if I had seen them, I just glanced at the subject line and didn't see they were decimals. I see it now that you mentioned it. Peo
