I am using ArcGIS 10.3 basic desktop to interpolate GPS soil points and then create a lime prescription map. I can easily interpolate the points however when I use the field calculator to enter the target lime formula for the desired pHw level I get an error message of 99999 that says a field name was not found or there were unbalanced quotation marks. The formula was produced by a leading university and has been used in numerous types of software so I don't believe it is the problem.
This doesn't appear to be either VB Script or Python, your only two options in the field calculator. As I'm not familiar with your subject matter whatsoever, can you please explain, in words, what that formula is supposed to do?
No, this still isn't in language I, or the field calculator, will understand. The field calculator works like: for each row in the attribute table, take some value(s) in another column(s), manipulate it somehow, and return some new value into the calculated column for that row.
Is "phw" the name of the column we are getting values from or calculating to? What does your notation phw[0,6.24] mean - something like if phw is between 0 and 6.24, apply this part of the formula?