Can I format a cell to round a number by 50 basis points (0.5)?

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

Guest

I am trying to format a number cell so that the decimal value rounds up to
the next .5. Is this possible? I
 
Hi!

You can't use formatting in that manner but you could use a function.

=CEILING(A1,0.5)

Or, put your current formula inside:

=CEILING(SUM(A1:A10),0.5)

Biff
 
You must log in or register to reply here.

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

Alternate Rounding Up & Down of .50 in a column 5
Rounding formula when using conditional formatting? 4
How to round a number up or down 3
Rounding Time to Nearest 5 Minutes 1
ROUND or "Precision as displayed"? 2
Need advice on my sumif formula (text ref.) 2
Round a repeating decimal from a formula... 14
Calculate to the third decimal and round up or down in cell 6

Back
Top