Simple - I need to retail round 12.03 to 11.99 and 12.05 to 12.09.
P Pete_UK May 6, 2008 #2 Round to the nearest 10 cents, then subtract 1 cent: =ROUND(A1,1) - 0.01 assuming your dollar value is in A1 - copy down as required. Hope this helps. Pete
Round to the nearest 10 cents, then subtract 1 cent: =ROUND(A1,1) - 0.01 assuming your dollar value is in A1 - copy down as required. Hope this helps. Pete
J joeb May 7, 2008 #3 Thank You Pete K!! Pete_UK said: Round to the nearest 10 cents, then subtract 1 cent: =ROUND(A1,1) - 0.01 assuming your dollar value is in A1 - copy down as required. Hope this helps. Pete Click to expand...
Thank You Pete K!! Pete_UK said: Round to the nearest 10 cents, then subtract 1 cent: =ROUND(A1,1) - 0.01 assuming your dollar value is in A1 - copy down as required. Hope this helps. Pete Click to expand...
