Forum Discussion
prachi1999
Nov 26, 2022Copper Contributor
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 ...
bosinander
Nov 26, 2022Iron Contributor
=IF(AND(B3>="50", C3>="50", D3>="50") , OR(F3="A",F3="B")),"p", "f")