If Function with Example

IF function is one of the most valuable functions in Excel. you can make logical comparisons.

IF(Something is True, then do something, otherwise do something else)

IF Examples :- 

If value is Equals to "RAM" Then return "OK" otherwise return "Not Ok"

=IF(A1="RAM","OK","Not Ok")

If value is Grater then to 5 Then return "OK" otherwise return "Not Ok"

=IF(A4>5,"OK","Not Ok")

If F1 is grater then 3 then (F1*2) cell value is multiple 2 and the condition of first condition false result is 0

=IF(F1>3,F1*2,0)

Microsoft Excel Basic

*The  Max function will return the largest (max) value in the selected range. 

*The Min function will display the smallest value in a selected set of cells.

*The SUM function adds all the numbers that are contained in cells.

*The COUNT function counts the number of cells that contain numbers

*The COUNTA function counts the number of cells that are not empty in a range.