Excel Functions

Introduction Let us being with basic understanding. In Microsoft Excel, the CONVERT function is used

Introduction to TRUNC Function TRUNC Function returns an integer after truncating the original number. In simple

Introduction to SUMPRODUCT Function SUMPRODUCT Function returns a value after sum and multiplies values from

Introduction to SUMIFS Function SUMIFS Function returns the sum of the numbers which meet multiple

Introduction to SUMIF Function SUMIF Function returns the sum of the numbers which meet the

Introduction to SUM Function SUM function returns the sum of the values supplied. In simple

Introduction to RAND Function RAND function returns a random number ranging from 0 to 1. In

Introduction to MROUND Function MROUND function returns a number after rounding it to a given

Introduction to MOD Function MOD function returns the remainder value after dividing a number with

Introduction to INT Function INT function returns the integer part of a decimal number. In simple

Introduction to EVEN Function EVEN function rounds a number to the nearest even number. If the

Introduction to ABS Function ABS Function returns a number after converting it into an absolute

Introduction to TRUE Function Logical functions in Excel are predefined formulas that evaluate a given

Introduction to OR Function Logical functions in Excel are predefined formulas that evaluate a given

Introduction to NOT Function Logical functions in Excel are predefined formulas that evaluate a given

Introduction to IFNA Function Logical functions in Excel are predefined formulas that evaluate a given

Introduction to IFERROR Function Logical functions in Excel are predefined formulas that evaluate a given

Introduction to IF Function Logical functions in Excel are predefined formulas that evaluate a given