rounding

  • Thread starter Thread starter Marcy
  • Start date Start date
M

Marcy

I am trying to figure out how to round a number down even
though it is greater than .5 ex: 29.57. I need to be able
to round it down to 29. Any ideas?
 
If you're always 'rounding down' to the integer part, you can use

=INT(A1)
 
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

Formula help 1
rounding up to the nearest 1000 1
Formula help 3
Round Function 5
Calculate to the third decimal and round up or down in cell 6
How to round a number up or down 3
Rounding up @ 3 instead of 5 4
Rounding 4

Back
Top