2) User defined functions: Product, Quotient, LCM and GCD

User defined functions: Product, Quotient, LCM and GCD

User defined functions can help in finding product, quotient, LCM, GCD etc.

Recall the steps to find Min, Max, Sum and Average:

1. Select the cell where the answer needs to be displayed
2. Open function wizard
3. Select the function category and function name
4. Select the data
5. Click OK

Product:

Product of the selected data can be found using the function ‘PRODUCT’. This function is found under the category ‘Mathematical’. Following same steps as recalled before and applying this function you can find the product.

 

Quotient:

Quotient is the remainder when a number is divided by another number. This can be found using the function ‘QUOTIENT’. This function is found under the category ‘Mathematical’. After you select the function from the function wizard, select two numbers where the first number will be taken as dividend and second number will be taken as divisor by the function. The resulting number by the function will be quotient.

 

LCM and GCD:

Similarly by applying the functions ‘LCM’ and ‘GCD’ found under the category ‘Mathematical’, you can find the Least Common Multiple and Greatest Common Divisor respectively.