Excel IF Formula - Free Excel Tutorial

If Value is Greater Than A Certain Value

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the logical test result. If you want to see if a value in one cell is greater than a specific value, you can use IF function to build a formula with logical test argument is “value>certain… read more »

Excel IF function check if the cell is blank or not-blank

If you want to check the value in one cell if it is blank or empty cell, then you can use IF function in combination with ISBLANK function or logical operator (equal to) in excel. Excel IF function check if the cell is blank Let’s see the generic IF formula with ISBLANK function and Logical… read more »

Excel IF formula with “Equal to” logical operators

The “Equal to” logical operator can be used to compare the below data types, such as: text string, numbers, dates, Booleans.  This section will guide you how to use “equal to” logical operator in excel IF formula with text string value and dates value. Formula example Description =IF(A1=B1,“TRUE”,”FALSE”) Returns TRUE if a value in cell… read more »

Sidebar