The formula looks like this
=IF($G4 <= K$2, IF($H4 >= K$2, "Y", ""), "")="Y"
I cannot for the life of me figure out why the last ="Y" is needed. It's driving me crazy! '
Help please!![]()
The formula looks like this
=IF($G4 <= K$2, IF($H4 >= K$2, "Y", ""), "")="Y"
I cannot for the life of me figure out why the last ="Y" is needed. It's driving me crazy! '
Help please!![]()
It's a formula in conditional formatting... it's got to return TRUE, or FALSE. It means "if the result of this nested if-formula...""... equals "Y", then apply the conditional format.Formula:
Please Login or Register to view this content.
Tim
![]()
Never stop learning!
<--- please consider *-ing !
Brilliant. Thank you. I used an 'And' function which served the same purpose and was a lot less complicated.
=AND($G4 <= K$2, $H4 >= K$2). It worked without adding the extra =Y at the end. I get that And will return a true value when both conditions are met.
wouldn't the nested if also return a Y value?
Only if G4 is smaller or equal to K2 *and* H4 is greater or equal to K2, which is what your alternative does. Both are equivalent.
Tim
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks