Rounding up numbers up or down.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to round a formula up or down to a specific number 4
Formula for counting frequency then sorting 5
Alternate Rounding Up & Down of .50 in a column 5
subtraction returning incorrect calue 5
Formula help 1
Round Function 5
IF and Round 5
How to round a number up or down 3

Back
Top