MATH AND TRIG FUNCTIONS
MATH AND TRIG group of functions contain very important and widely used functions in Excel.
MATH AND TRIG functions help us to use many mathematical formulas and find out the results within seconds. Mathematical functions such as SUM, SUMIF, QUOTIENT, RAND, RANDBETWEEN and many more functions are included in this group.
Here is the list of functions which fall under this category. Click the function for its further details i.e. formula syntax, examples, purpose etc.Ma
MATH AND TRIG FUNCTIONS
HOW TO DO FACTORIAL IN EXCEL ?
INTRODUCTION Choosing the ways in which we can make the arrangements creates the pattern in which we multiply the number …
EXCEL FUNCTIONS-COMBINA
INTRODUCTION COMBINA function comes under the MATH AND TRIG category in Excel. The COMBINA function returns the number of possible …
EXCEL FUNCTIONS-CEILING
INTRODUCTION CEILING FUNCTION has become redundant now and is only given here for the friends who has Excel older than …
HOW TO USE RANDARRAY FUNCTION IN EXCEL ?
Table of Contents INTRODUCTION PURPOSE OF RANDARRAY FUNCTION IN EXCEL PREREQUISITES TO LEARN RANDARRAY FUNCTION SYNTAX: RANDARRAY FUNCTION EXAMPLES: RANDARRAY …
EXCEL FUNCTIONS-TRUNC
INTRODUCTION Many times , while performing the mathematical calculations we can come across a particular situation when we need to …
EXCEL FUNCTIONS-SUMPRODUCT
INTRODUCTION SUMPRODUCT FUNCTION available in Microsoft Office is a very useful function when it comes to find out the sum …
EXCEL FUNCTIONS-SUMIF
Table of Contents INTRODUCTION PURPOSE OF SUMIF IN EXCEL PREREQUISITES TO LEARN SUMIF SYNTAX: SUMIF FUNCTION EXAMPLE:SUMIF FUNCTION IN EXCEL …
EXCEL FUNCTIONS-SUM
INTRODUCTION SUM function comes under the MATH AND TRIG FUNCTIONS category in Excel. It is again one of the frequently …
EXCEL FUNCTION-SUBTOTAL
INTRODUCTION The SUBTOTAL FUNCTION is used to find out the subtotal or a specified range within a database or bigger …
EXCEL FUNCTION-ROUND
INTRODUCTION The ROUND FUNCTION is very useful function in day to day report making. Many times we come across the …