#NAME? In cell with correct Foruma

Originally Posted by XOR LX

Hi,

What is your equivalent of the IF function in the language version you are using? Are you sure that you are not using a version of Excel in which SE() is NOT the correct syntax for this function (perhaps you are actually using an English version of Excel)?

Regards

1/. Have you tried this?

Formula:

=IF(B5="2","é dois","Outra coisa")

You might have to change the commas to semi-colons.

2/. Why is B5 text and not a number?

Hi, thanks for replyes.
My Software is in português. Then IF() function is SE() function. For the hurry I forgot translate the example workbook. But it is not the problem cause.

You can do a simulation of the error right there. Folow this steps:
1- put a wrong formula in the cell. How IFFF = (B2 = 3; "true", "false").
2-So I created a macro that fixes it.
Sub XXX()
Selection.Replace What:="IFFF(", Replacement:="IF(", LookAt:=xlPart, _
SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

The result is a correct formula but is not recognized by Excel like a formula.