How do I make a formula (within the same cell) round to the nearest 5? Thanks - Kim
K kjcramp Apr 10, 2006 #1 How do I make a formula (within the same cell) round to the nearest 5? Thanks - Kim
K kjcramp Apr 10, 2006 #3 The second choice with the formula works, although it rounds up if ther is any value behind the decimal at all, but it's close enough. Thanks again
The second choice with the formula works, although it rounds up if ther is any value behind the decimal at all, but it's close enough. Thanks again
D Dave Peterson Apr 10, 2006 #4 Sorry, I misread the question... Maybe... =ROUND(A1/5,0)*5 or =ROUND(YourFormulaHere/5,0)*5
