Hello, does anybody know if it is possible to have a cell as the true/false value?
I keep getting errors with this consequential formula:
=IF(K18 < B18, B18, K18)
What I need Excel to do is use the largest value of the cells B18 and K18.
I have been searching the web but can't seem to find the proper formula, so it occurred to me that maybe cells can't be true/false values...
Hope somebody knows so I can quit my queste and get on with it