Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Roundup/Rounddown or Int

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Roundup/Rounddown or Int

Resolved · Low Priority · Version 2007

Reply 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.

For upcoming training course dates see: Pricing & availability

Reply 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

Mon 8 Nov 2010: Automatically marked as resolved.

Excel articles

· That's The Wonder Of Autofill
· Understanding XML Within Excel
· Utilise the web's information banks with Microsoft Excel
· Improve Performance Of Your Excel Macros
· Interesting Things About Charts In Excel 2003

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips