If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Value of String used in Calculation?
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 |
#2
|
|||
|
|||
Value of String used in Calculation?
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 |
Thread Tools | |
Display Modes | |
|
|