Rounding up and down

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

Guest

How do I write a formula that will allow me to round down to a whole number
if the decimal is equal to or less than .49 and round up to the next higher
whole number if the decimal is equal to or greater tthan .50? (Currency
formating)
 
Joe said:
How do I write a formula that will allow me to round down to a whole
number
if the decimal is equal to or less than .49 and round up to the next
higher
whole number if the decimal is equal to or greater tthan .50?
(Currency
formating)
Click to expand...


=round(A1,0) will work for you.
 

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

How to round a number up or down 3
Calculate to the third decimal and round up or down in cell 6
if function with rounding 4
Rounding 3
Formula help 1
How to Change rounding precision from .5 to .25 1
Alternate Rounding Up & Down of .50 in a column 5
Excel Excel 2007 won't stop rounding down my formula results! 5

Back
Top