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

Thanks for responding! I entered the formula result of my pricing routine as
"A1" in your function and received an error. I'm trying to puzzle out how to
fix the problem. I have received one solution that works, but I know there is
often many alternates to a problem and I want to learn from them all...
The error highlights "0.01" in the middle of the function statement...
--
TENNISPLAYER


"Arvi Laanemets" wrote:

Hi

Maybe
=ROUND(A1+0.01;1)-0.01


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"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