I'm trying to use this formula to output "Tie" when the result is a draw:
=IF(B6>C6,B6-C6,IF(C6>B6,C6-B6,”Tie”))
Instead of giving me what I want, it gives me a "name" error.
What am I doing wrong?
I'm trying to use this formula to output "Tie" when the result is a draw:
=IF(B6>C6,B6-C6,IF(C6>B6,C6-B6,”Tie”))
Instead of giving me what I want, it gives me a "name" error.
What am I doing wrong?
As the comments point out the quotes around Tie are indeed the problem. If you use the following formula with the expected quotes your formula will no longer give you the #NAME?
error:
=IF(B6>C6,B6-C6,IF(C6>B6,C6-B6,"Tie"))