admin

IF Function in Excel

IF Function in Excel : In this excel tutorial we will learn about syntax, usage and nesting of IF function. Description: The IF function is the most popular function for a logical test in Excel worksheet. It compares two values and performs a specific task based on given TRUE or FALSE value. Syntax: =IF(logical_test, [value_if_true],

IF Function in Excel Read More »

EXACT Function in Excel

Exact function in Excel : In this tutorial, we will learn about syntax and usage of the Exact function. Description : Exact function in excel is used to compare two strings (text) and returns TRUE if the string is same, otherwise return FALSE. Exact function is case sensitive so small and capital letters are not equal.

EXACT Function in Excel Read More »