I itty Oct 8, 2003 #1 After some calculations i got values like 3,12,6,32 etc. Can sombody help me to roundup these figures to the nearest multiple of 5
After some calculations i got values like 3,12,6,32 etc. Can sombody help me to roundup these figures to the nearest multiple of 5
P Paul Oct 8, 2003 #2 itty said: After some calculations i got values like 3,12,6,32 etc. Can sombody help me to roundup these figures to the nearest multiple of 5 Click to expand... For a number in A1, you could use =CEILING(A1,5)
itty said: After some calculations i got values like 3,12,6,32 etc. Can sombody help me to roundup these figures to the nearest multiple of 5 Click to expand... For a number in A1, you could use =CEILING(A1,5)