Excel does not recognise function name in a formula

Hi,

i bumped into a similar problem
Excel shows a #Name? error
the cell is formatted as general
and Show Formulas is off
for some reason it does not recognize ISERROR function name
after i hit F2 and Enter it shows the result
therefore i assume the formula is OK
F9, Ctrl-Alt-Shift-F9 does not help
any ideas?
the only thing i can think of is that i use VBA to enter the formula and something goes wrong now (but worked before)

thanx,

Sasha

Here we go

If this "ЕСЛИОШИБКА" means "ISERROR" in Russian then your setup is not right.

If you wish to check a cell value for error the formula in B column should be

Please Login or Register  to view this content.

this well evaluate to "True" or "False" depending on if there is an error in A3 or not. You can also use

Please Login or Register  to view this content.

and the you will get 1 or 0

Alf

my bad
thought Excel functions should change the name according to MS Office locale
this is IFERROR function, not ISERROR

SK

Originally Posted by newdoverman

ЕСЛИОШИБКА translates to IFERROR and ЕОШИБКА translates to ISERROR according to a coiple of translation sites.

Make sure that the Regional Settings on your computer are correctly identifying Russian as the Language.

If you are getting the #NAME? error, it means that there isn't a Defined Name or Function of that name. If there is a Defined Name that matches you would get a #Ref error.

This is strange.

your transation is exactly right
and i get why the name of the function is not translated in English — this is because the name is not recognised as a function name
i checked the file, there are no confusing names
also i removed all user defined functions — this did not help either
i do not think this is a typo because a) this did work before, only stopped working yesterday, b) sequence F2, Enter helps (i illustrate this in attachements, screenshot #3 is made after i pressed F2, then Enter in B4 cell)
this is how it looks now
1.png
2.png
and this is after i press F2, Enter in B4 cell
3.png


i also expect that this time function name in B4 cell will be translated, pls let me know

in case this may give you a clue if i copy-paste b3 - it gives me the same error
if i copy-paste b4 after it is being recognised, it pastes just fine

tried on another computer — did not work either
since the same formula still working in other workbooks its not a matter of excel settings
and i tried to copy the formula to a new workbook, it did not work
therefore the problem i think with the formula, not the corrupt file

no previous versions
and restoring backups will lose a couple days work, won't go there
anyway i modified the algorythm to avoid this error
just hoped to learn from you what could cause this problem cause this is kinda weird situation
thx for hints anyway

Maybe you should use the English name of the function?

I use the Spanish version of Excel and I had the same problem using +PROMEDIO(), which is +AVERAGE() in English. When the macro included:
Cells(8, 10) = "=+PROMEDIO(G5:G8)"
I got the equivalent of #Name? error in cell J8.

When I changed that to:
Cells(8, 10) = "=+AVERAGE(G5:G8)"
it worked, and the formula in cell J8 was:
=+PROMEDIO(G5:G8)

It seems like Excel has trouble translating from a foreign language to English after writing a cell, but still can translate in the other direction.

Wacatay,

using English function names is not an option
Russian Excel gives #NAME? error for English function names

Spanish Excel also gives #NAME? error for English function names when you write or Cut&Paste it in the cell,
NOT when VBA writes it in the cell.

Wacatay,

originally i came across this error when writing formula using VBA and the name of the function was in English
the thing is that sometimes it was recognised as a function and sometimes Excel considered it as a text
could not find any consistency in how it happened