when entering below if formula it gives me name error
=IF(B6>C6,B6-C6,IF(C6>B6,C6-B6,”Tie”))
I'm trying to enter the above statement to appear Tie when the result is a draw, but it gives me the error "name" instead. What am I doing wrong? pls help!
=IF(B6>C6,B6-C6,IF(C6>B6,C6-B6,”Tie”))
I'm trying to enter the above statement to appear Tie when the result is a draw, but it gives me the error "name" instead. What am I doing wrong? pls help!
No comments:
Post a Comment