whole numbers not decimals

[Brown]

I am working on a sheet to calculate some inventory and need some answers to be returned and used as whole numbers not decimals or fractions.
Can you help? I have tried formatting the cell as custom, and number with no decimals, but it shows a 1 (for example) but still calculates the formula using .66 (for example)
Is there are way to do this? Or did I not make any sense?
Thanks
Brown

 

[VoG]

Try

=TRUNC(your formula)

or perhaps

=ROUNDUP(your formula,0)

 

[Brown]

Thans I will try it now.
Brown

 

[Brown]

thanks that worked
Brown

Man the things you can learn on this board is great!