Forum Discussion
If Value Error
=IF(AND((B3:D3) >="50", OR(F3="A",F3="B")),"p", "f") On calculating the steps, it is the issue with the range. And even it runs on a single cell, it is just the issue with the range. Suggestions ...
A comparison >= can only work with a number and not with a text "50".
This is how it should work.
=IF(AND(B3:D3>=50,OR(F3="A",F3="B")),"p", "f")