software

RThis is for a price sheet for a new business

I have cells with formulated numbers that I want to round up or down
depending to X,X99.95 or X,X49.95.Um....did you forget that you posted pretty much the same question to the
same newsgroup around 3 hours ago?
(and got 3 responses)

***********
Regards,
Ron

XL2002, WinXP-Proquot;Eric Foucrierquot; wrote:

gt; RThis is for a price sheet for a new business
gt;
gt; I have cells with formulated numbers that I want to round up or down
gt; depending to X,X99.95 or X,X49.95.
gt;
gt;
gt;
gt;

You really don't give quite enough information (i.e., where the
breakpoints between rounding up and down should be), but one way might
be:

=ROUND(A1*2,-2)/2-.05

In article gt;,
Eric Foucrier gt; wrote:

gt; RThis is for a price sheet for a new business
gt;
gt; I have cells with formulated numbers that I want to round up or down
gt; depending to X,X99.95 or X,X49.95.