What's wrong with this formula?

=IF(F17>F18;B17;B18)+IF(F17=F18;A17;A18)

It says #VALUE!

IF function, one of the logical functions, to return one value if a condition is true and another value if it's false.

‘=IF(logical_test,[value_if_true],[value_if_false])’

=IF(F17=>F18;B17;B18 <----logical_test,...........)

I replicated this quickly just now and found no errors.

The only thing I had to change was the ";" to "," as I am not sure if it is Excel version or not but I use "," in my formulas.

Yeah, here it is.

(My workbook is in Danish and I can't change it, but tell me if you get it in danish and I'l translate for you)

Originally Posted by ladbroke

I replicated this quickly just now and found no errors.

The only thing I had to change was the ";" to "," as I am not sure if it is Excel version or not but I use "," in my formulas.

It unfortunatately didnt solve the problem, thanks anyways. But what version do you use.

Originally Posted by thomexcel

Yeah, here it is.

(My workbook is in Danish and I can't change it, but tell me if you get it in danish and I'l translate for you)

Here it should be

Originally Posted by Norie

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.

The artbook is a simulation of an upcoming tournmaent, I am trying to learn some formulas for Excel, if you would want to know what the names are.

Originally Posted by Norie

Which cell is the problem formula in?

By the way, I'm in the UK and the formulas 'translated' just fine, ie ; was replaced with ,.

Section 1 H16

Originally Posted by Norie

Just found a formula on the sheet named 'Section 1' in cell H16 that's returning #VALUE! - when evaluating the formula it appears it's pulling a text value from B18.

Yes, I want Excel to show the name of the winner of the match between Benoit Paire & Tommy Hass. The A18 is that value I want to show before I type the results in the cells for the match between Benoit Paire & Tommy Hass. If that makes sense.

Originally Posted by Norie

If you want to concatentate text use & instead of +.

Thanks, but it didn't fix the problem precisely, I want it to show nothing if F17 is the same as F18, but if F17 is bigger than F18 I want it to show the value of B17, and if F18 is bigger than F17 I want it show the value of B18.

Originally Posted by FlameRetired

Both uploads work at my end and return correct results.

No #VALUE! Error?

Originally Posted by Norie

If you want to work with text values then you need to use the & string operator instead of the arithmetic + operator, otherwise you'll get the error(s) you are describing.

Yeah I use the & it still dosen't work 100 %, but I can just go with what I tried first. Thanks for all your help.