Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

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

2 Answers 2

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"))

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

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.