If Value Error

[prachi1999]

=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

[#2]

=IF(AND(B3>="50", C3>="50", D3>="50") , OR(F3="A",F3="B")),"p", "f")

[#3]

@prachi1999 

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")

[#4]

=IF(AND(C3>=50,D3>=50,E3>=50,F3="A"),"P","F")