This formula is based on the IF function, configured with a simple logical test, a value to return when the test is TRUE, and a value to return when the test is FALSE. In plain English: if Value 1 equals 1, return Value 2. If Value 1 is not 1, return an empty string ("").
Note if you type "" directly into a cell in Excel, you'll see the double quote characters. However, when you enter as a formula like this:
You won't see anything, the cell will look blank.
Also, if you are new to Excel, note numeric values are not entered in quotes. In other words:
Wrapping a number in quotes ("1") causes Excel to interpret the value as text, which will cause logical tests to fail.
Checking for blank cells
If you need check the result of a formula like this, be aware that the ISBLANK function will return FALSE when checking a formula that returns "" as a final result. There are other options however. If A1 contains "" returned by a formula, then:
To test a cell and take some action if the cell is blank (empty), you can use the IF function. The formula in cell E5 is: = IF ( D5 = "" , "Open" , "Closed" ) How this formula works The logical expression ="" means "is...
To take an action only when the cell is not blank (not empty), you can use a formula based on the IF function. In the example shown, column D holds task complete dates. The formula in cell E5 is: = IF ( D5 <> "" , "Done...
If you want to take an action when a cell value is greater than a certain value, you can use the IF function to test a value and return one value if the test is true, and another if the test is false. In the example shown, we are using this formula...
The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions....
The IF function is very versatile. You can use it whenever you need to test a condition and take an action based on the result. You can even combine multiple IF statements to check multiple conditions.
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.