MICROSOFT EXCEL FUNCTIONS- MATH AND TRIG

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

EXCEL FUNCTIONS-COMBINA

INTRODUCTION COMBINA function comes under the MATH AND TRIG category in Excel. The COMBINA function returns the number of possible …
Read More

EXCEL FUNCTIONS-CEILING

INTRODUCTION CEILING FUNCTION has become redundant now and is only given here for the friends who has Excel older than …
Read More

EXCEL FUNCTIONS-TRUNC

INTRODUCTION Many times , while performing the mathematical calculations we can come across a particular situation when we need to …
Read More

EXCEL FUNCTIONS-SUMPRODUCT

INTRODUCTION SUMPRODUCT FUNCTION available in Microsoft Office is a very useful function when it comes to find out the sum …
Read More

EXCEL FUNCTIONS-SUMIF

INTRODUCTION If you already know the very basic SUM FUNCTION , this SUMIF function is an advanced version of that, …
Read More

EXCEL FUNCTIONS-SUM

INTRODUCTION SUM function comes under the MATH AND TRIG FUNCTIONS category in Excel. It is again one of the frequently …
Read More

EXCEL FUNCTION-SUBTOTAL

INTRODUCTION The SUBTOTAL FUNCTION is used to find out the subtotal or a specified range within a database or bigger …
Read More

EXCEL FUNCTION-ROUND

INTRODUCTION The ROUND FUNCTION is very useful function in day to day report making. Many times we come across the …
Read More

EXCEL FUNCTIONS-RANDBETWEEN

INTRODUCTION RANDBETWEEN FUNCTION comes under MATH AND TRIG function class in Excel. RANDBETWEEN FUNCTION RETURNS A RANDOM NUMBER IN A …
Read More

EXCEL FUNCTIONS-RAND

INTRODUCTION RAND FUNCTION helps us to generate a random number. Random number is used for creating some application where we …
Read More