rounding a number created by a formula to a retail price
 

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.

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.

rounding a number created by a formula to a retail price
 

=ROUNDDOWN(A1,1)+0.09


"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.

rounding a number created by a formula to a retail price
 

Assuming nothing happens to 0

=MAX(0,ROUND(your_formula,1)-0.01)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Jack" wrote in message
...
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.