Fri 29 Oct 2010, 13:01Delegate Eunice said...
Eunice has attended:
Excel Intermediate course
Excel Advanced course
Roundup/Rounddown or Int
On Unit 3 of the Excell Intermediate we spoke about using the INT function but I can'r remember when we might use it.
Mon 1 Nov 2010, 13:58Trainer Simon said...
RE: Roundup/Rounddown or Int
Hi Eunice,
Thank you for your question and welcome to the forum.
The INT function is used to round a number downwards towards the next lowest number and remove all decimal places leaving the whole number only.
Please find the following link below explaining the differences:
http://spreadsheets.about.com/od/excelfunctions/qt/080809_int.htm
I hope this answers your question.
Regards
Simon
