I have a basic formula (using basic math operators, no excel calls) that is
being impacted by a 'general text' value in a field. So, if my formula is
A1/A2*A3, I will get a different answer if A1 is 0 vs some random text.
Should I expect text in a field to actually be converted to some value in a
calculation? Is there a way to get it to not do that?
--
Brad Eck
<a href="http://www.sitesdynamic.com"SitesDynamic</a
<a href="http://www.eternalelement.com"Eternal Element</a
<a href="http://www.basketsetcetera.com"Baskets Etcetera</a

If A1 is zero or blank you should get 0
If A1 has text you should get #VALUE! (an "error value")
What do you get?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Brad" wrote in message
...
I have a basic formula (using basic math operators, no excel calls) that is
being impacted by a 'general text' value in a field. So, if my formula is
A1/A2*A3, I will get a different answer if A1 is 0 vs some random text.
Should I expect text in a field to actually be converted to some value in
a
calculation? Is there a way to get it to not do that?
--
Brad Eck
<a href="http://www.sitesdynamic.com"SitesDynamic</a
<a href="http://www.eternalelement.com"Eternal Element</a
<a href="http://www.basketsetcetera.com"Baskets Etcetera</a