How can i get a blank cell instead of FALSE in the following:
=IF(AND(H24="Test Route 1",J24<>""),J24+$I$1,IF(AND(H24="Test Route 2",J24<>""),J24+$I$2, IF(AND(H24="Test Route 3",J24<>""),J24+$I$3)))
How can i get a blank cell instead of FALSE in the following:
=IF(AND(H24="Test Route 1",J24<>""),J24+$I$1,IF(AND(H24="Test Route 2",J24<>""),J24+$I$2, IF(AND(H24="Test Route 3",J24<>""),J24+$I$3)))
How aboutFormula:Please Login or Register to view this content.
wow, thanks much Fluff13, that worked perfectly!
You're welcome & thanks for the feedback.
The only thing I would add is that Fluff13's addition technically does not return a blank cell, it returns a null string. The cell still contains something, it is just not visible.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks