View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PRICEMGR
 
Posts: n/a
Default ROUND CENTS TO EITHER 49 OR 99 AMOUNTS

THIS IS A GREAT SOLUTION! For both signage and to denote for sales staff the
current years inventory, we use pricing levels that rotate common endings.
Next year maybe ..98 or .97, etc. This solution automates what used to be
ALOT of hand tuning of our excel based price tables!
Many Thanks!
--
TENNISPLAYER


"Biff" wrote:

Hi!

What if a price is $15.00, do you want that rounded to $15.49?

Try this:

=IF(MOD(your_formula,1)<0.5,INT(your_formula)+0.49 ,INT(your_formula)+0.99)

Biff

"PRICEMGR" wrote in message
...
We manage prices of thousands of items that are especially volatile
currently. We want to round all cents <.49 as .49 and .50 as .99. As the
cell contents are already a formula result, I'd like to "tack on"
something
else, if possible, rather than adding another column. I've reviewed the
current "rounding" topics and can't quite find the working of
conditionals..
Thanks All from a new participant!
--
TENNISPLAYER