I have an Excel spread sheet with my cost on it, and I would like to mark
this up and round the price to the next higher $xx9.99. The retail values in
the price list range from $10 to over $1000.
The basic formula that I use to calculate retail price is /.6. For example
if the product costs $160, I would calculate that to $266.66 with the basic
formula.
I would like Excel to kick out a price of $269.99. I have tried several
different ways to get this output. The best way I have found to get close is
doing a custom cell format of
_($* #,##0.99_);_($* (#,##0.99);_($* "-"??_);_(@_)
which will round the price to $266.99.
What else can I try to get the desired output?
--
Thanks,
Jonathan
Bookmarks