Round to the nearest 9 cents
Thank You Pete K!!
"Pete_UK" wrote:
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
On May 6, 10:22 pm, joeb wrote:
Simple - I need to retail round 12.03 to 11.99 and 12.05 to 12.09.
|