rounding a number created by a formula to a retail price
Try:
=ROUND(A1+0.01,1)-0.01
Scott
Jack wrote:
I want to round a price that i have created by using a formula to .09, .19,
.29, ......99. Example - the price I created by using a formula is $5.64 and
I would like to round it to $5.59 or $5.69.
|