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 please
3 Replies
- =IF(AND(C3>=50,D3>=50,E3>=50,F3="A"),"P","F")
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")- =IF(AND(B3>="50", C3>="50", D3>="50") , OR(F3="A",F3="B")),"p", "f")
