#INVALID OPERATION Error

Julie Nelson

I've been getting an #INVALID OPERATION Error for the last several hours. The error was coming up in a different formula in a different column (that was also attempting to multiply a number times the Tax Rate), and as I stripped out criteria, it became apparent that Tax Rate is causing the error. Below is a simplified formula, to try to understand what is causing the error.

Test & Tax Rate are both "Text/Number" column types.

Using the same formula, but replacing [Tax Rate]@row with .05, returns the correct answer (5)... =100 * .05

Has anyone ever got this same error when referencing data in a column populated by DataMesh? I think that has happened to me before (and the next day, when I opened the sheet again, the error was gone) and the interesting thing is that the range (column) in the INDEX(MATCH) formula that's returning the .05 in the example below... is populated by DataMesh.

Tax Rate formula: =INDEX({Sheet 2_Tax Rate}, MATCH(County@row, {Sheet 2_County}, 0))

I have wasted so much time on this - I am losing my mind! I certainly appreciate any help anyone can offer!

Paul Newcome

Exactly how is this filled out: {Sheet 2_Tax Rate}?

Julie Nelson

The Tax Rate in Sheet 2 was a formula based on another column. This morning I took out the formula and pasted the values into the column, to see if that was causing the issue, but I'm still getting the #INVALID OPERATION error.

Julie Nelson

Paul, I figured this out (by trial and error). The issue was that the tax rate was missing the leading zero in front of the decimal! 0.05 works, but .05 does not.