MS Excel "IF" formula - how to p range (B2:G2) of arguments?

=IF(B2<50,"fail","p") This is working fine. but how to make the following work fine too. =IF(B2:D2<50,"fail","p"). I want to check each and every value from B2 to G2 for the same condition. when i try this i am getting some error like this - #VALUE!. please help me out. Thanks in advance.