I am using this custom formula for my sheet:
=if(B2<((B$7/4)*$A2), 1, 0).
However, this also highlights the rest of the cells that are empty.
How do I exclude empty cells from this formula?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
=and(len(B2), ... ) where ... is your current condition. The length value of 0 corresponds to False; any positive value is True.
A more explicit, but longer version is using
not(isblank(B2)) instead of
By the way, your construction
= if( condition, 1, 0) is not necessary; simple
= condition works. E.g.,
=B2<((B$7/4)*$A2) is a valid formula returning True or False according to the condition.
So, a complete formula would be