From the course: Google Sheets: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Find integer and remainder components of numbers and operations

Find integer and remainder components of numbers and operations - Google Sheets Tutorial

From the course: Google Sheets: Advanced Formulas and Functions

Start my 1-month free trial

Find integer and remainder components of numbers and operations

“

- [Instructor] Many business calculations give results that have both an integer component and a decimal component. In this movie, I will show you how to find the integer component of a division operation or any other operation, as well as the whole number remainder from division. In this scenario, let's suppose that I have an olive oil company and I have 12 bottles per case. What I'd like to discover is how many cases I can create based on a specific number of bottles. So I'm not worried about how many bottles I have left over, I just want to know how many full cases I can create. To create those formulas, I can use the int function, which is short for integer. The I-N-T function rounds a number down to the nearest integer, so basically it strips off the decimal point. To demonstrate, I'll click in cell C2 and type an equal sign, and then I-N-T which is the integer function, left parentheses, and the value will be the calculation of A2, which is my number of bottles, divided by the…

Contents