Making a sum round down?

[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

 

[JE McGimpsey]

One way:

=TRUNC(SUM(O2:O17)/5+(O24+H21)/10000)

 

[Griff]

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.

 

[Dave Peterson]

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.