Rounding up numbers up or down.

E

Eric Foucrier

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.
 
R

Ron Coderre

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-Pro
 
J

JE McGimpsey

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
 
Top