Dan said:
If the criteria is not met using the IF function, how do I get a blank
cell?
The way to get excel to perform no action within a formula is with empty
quotation marks.
This gives the appearance of a blank cell.
Likewise a formula to test cell A1 to see if the number 5 was there, post
the word yes if it were, and do nothing if it were not would look like this:
=IF(A1=5,"YES","")
Notice the empty quotes at the end of the formula.
Now, you could remove the word yes leaving empty quotes, and instead place
the word no in the empty quotes at the end of the formula and it would post
NO until the number 5 was present in cell A1.