0

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?

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

2 Answers 2

3

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

1

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .