Round to the nearest whole number

[Morfi]

I want a calculation to yield a result that is a whole number. Is there a way of doing this where it won't give a result that's just rounded not to include decimal places i.e. if I increase the number of decimal places, it will still be the whole number.

I want to work out 5% of a number so my formula is =E5*0.05. Can I add something to this to result in the calaculation giving a whole number?

Thanks

 

[VoG]

Try

=ROUND(E5*0.05,0)

 

[Morfi]

That works. Thanks for that!!