#NAME? In cell with correct Foruma

Hi
Know when Excel recognizes a number as text?
How to solve this in macro? Say in macro why I have to do this on multiple worksheets with MANY cells in which this problem occurs.

Like the number problem I have a similar problem on a formula that Excel is recognizing as #Name?. I know what You thought, but the formula is correct. Is a simple If, see exactly what is typed in the cell = IF (B5 = "2", "two is"; "Another thing")

If I enter the cell and press enter (press F2 and enter, even without changing anything) Excel recognizes the formula. But like as the problem of numbers recognized as text, I can not edit cell by cell. I need a macro to solve this problem happens in 12 columns of my spreadsheet with over 5,000 rows ¬ ¬

Sorry for the first language mistake. I have arranged my question, now in english.
Any idea? Thanks

Hi Richard. You say like as:
ActiveSheet.Calculate
I try now but not work, and the automatic calculated is able.

Ok Richard, see this telluric forces. Kkkk!
It only recognizes the formula when it enters and exits the cell, even without changing anything.

To do this (in the attach in previous post), put a wrong formula in the cell. How IFFF = (B2 = 3; "true", "false"). 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.
How can I fix this by macro?

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:

Please Login or Register  to view this content.

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.

Hi Marcol.
You're right. But this is not the focus of my problem. Is only a exemple.
My problem is: How, by macro, I can make Excel recognize that there is a formula in cell C5?