Problems to round off

[Dawei]

Hi,

I've got a problem. I have a cell that is called "Number of containers", this cell affects my "Freight costs" and several other cells. I want this cell to never contain decimals, I have used the format menu and changed the number of decimals shown but that does not affect the number itself. It still uses decimals when calculated. I want this cell to use no decimals and also to always be rounded off downwards (since there can never be more than a certain number of items in a container). Can I use the ROUNDDOWN function?

How do I do this?

Thankful for any help!

David

 

[tactps]

Or:
=roundup(D6/D16,0)