Using OR Formula in MS Excel

 

Using OR Formula in MS Excel

This is the Best formula for using or function with IF function.

=IF(OR(B2>30, C2>20), "Good", "Bad")

Using Multiple IF Formula in MS Excel 

        =IF(A1="10x12",120,IF(A1="8x8",64,IF(A1="6x6",36)))  

          Result: 120                         

 

        =IF(A2="10x12",120,IF(A2="8x8",64,IF(A2="6x6",36))) 

          Result: 64     

 

        =IF(A3="10x12",120,IF(A3="8x8",64,IF(A3="6x6",36)))

          Result: 36