E.g. 2,3 should become 2,50 2,6 should become 3,00 6,51 should become 7,00 etc...
V Vincent Dec 29, 2004 #1 E.g. 2,3 should become 2,50 2,6 should become 3,00 6,51 should become 7,00 etc...
N Nick Hodge Dec 29, 2004 #2 Vincent Try this =CEILING(A1,0.5) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected]
Vincent Try this =CEILING(A1,0.5) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected]
