Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to use this formula to output "Tie" when the result is a draw:


Instead of giving me what I want, it gives me a "name" error.

What am I doing wrong?

share|improve this question
Are the curly-quotes that I see displayed around "Tie" in your actual formula? – chuff Jun 3 '13 at 2:35
Yes... The quotes look off there... Could also try this: =IF(B6=C6,"Tie", ABS(B6-C6)) – BrianAdkins Jun 3 '13 at 3:21

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:


share|improve this answer

Instead of using two IF's try: =IF(B6=C6,"Tie",ABS(B6-C6))

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.