G
GoBucks
I'm working on a pricing worksheet that calculates a product cost +
freight+margin to come up with a suggested product price. What I'd like to
be able to do is write a formula that converts all pricing to end with a 5 or
9. If the price already ends in a 5 or 9, nothing should change. If the
price ends in a 1,2,3 or 4, it should roundup to a 5. If the price ends in
6,7,8 it should round up to 9. If the pricing ends in zero, it should round
down to 9.
For instance:
$4.24 becomes $4.25
$3.26 becomes $3.29
$2.00 becomes $1.99
I'm guessing this will result in a doozy of a formula, but thought I'd
check.
Thanks in advance for your replies!
freight+margin to come up with a suggested product price. What I'd like to
be able to do is write a formula that converts all pricing to end with a 5 or
9. If the price already ends in a 5 or 9, nothing should change. If the
price ends in a 1,2,3 or 4, it should roundup to a 5. If the price ends in
6,7,8 it should round up to 9. If the pricing ends in zero, it should round
down to 9.
For instance:
$4.24 becomes $4.25
$3.26 becomes $3.29
$2.00 becomes $1.99
I'm guessing this will result in a doozy of a formula, but thought I'd
check.
Thanks in advance for your replies!