Making a sum round down?

  • Thread starter Thread starter Griff
  • Start date Start date
G

Griff

Hi there. I have a larger than normal sum formula, and sometimes th
result has a decial. I need it to round down, but by default Excel i
rounding up. How can I make it round down?

Here is my sum: =SUM(O2:O17)/5+(O24+H21)/1000
 
WOOHOO! Thanks!

By the way, I'm not getting email notification of any repies, even when
I left the box ticked... Just thought I'd mention it.
 
You may want to mention it directly to Mr. Rubin.

There's a link at the bottom of the url that you have included in your post.
 
Back
Top