NA() and #N/A may have a different representation in a non-English
localization of Excel. Look up the "Information Function" for an error that
means "no value is available". and use this in your formula.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
---------------------------------
When I do this:
=IF((B120);(C12/B12);NA())
I get an error in the empty field:
#NAME?
If I do this in the field:
=IF((B120),(C12/B12),NA())
I get an error saying:
Error in the formula.
Marco