need a nested if/and formula for a single cell sorted out - semi complex but beyond me

Originally Posted by NU2vba

Small correction to cell reference in formula- F2<=22 should read F5<=22

Well, I changed that, but found it behaved pretty much like the solution SDCh offered, namely that:

if f3=16 and f7=23, then f8=Free. However. one of the conditions needed is that to indicate "free", f3 eeded to be 15 or less AND f5 had to be 22 or less.

Neither of those 2 conditions was met in this example, yet "Free" is still the result.

Again NU2vba, thank you for trying.