Formula for IF cell is NOT BLANK and value < 'x"
Looking for some help from the formula guru's out there.
Trying to write a formula for is a cell is not blank, and then value of the cell is less than 'x'.
I have the cell < 'x' already sorted, just trying to work out how to add the IF NOT BLANK part of the formula in as well.
Any help appreciated.
Help Article Resources
Check out the Formula Handbook template!