Formula with a # result

L_123

Yeah np. One of my first steps in troubleshooting my own formulas is to delete all the closing parenthesis and hit enter so the program recalculates the amount. Sadly that wasn't my first thought in troubleshooting this one but I got there haha

Laura

=column9 * column10 

The Result I'm getting is Invalid Operation

 

Column9 = the formula just created with the result being either 50, 75 or 100

 

Column10 = (Column3)9 / (Column3)8 * 100    

 

 

 

Laura

They're all Text/Number Columns

L_123

use brackets not parenthesis for column identifiers.

[Column3]9/[Column3]8

You should also use parenthesis to denote operation order. If you are trying to multiply the result of what is divided then it would be

([Column3]9/[Column3]8)*100

If you are trying to multiply the denominator by 100 then

[Column3]9/([Column3]8*100)

L_123

If column 10 is working then the only issue i can think of is some sort of data type issue with column3

Laura

The Formula I have in Column10row# works

When I'm attempting to multiply the results in Column9 x results in Column10

is when I get the Invalid Operation Error 

=(Column9)10 * (Column10)10

 

 

L_123

can you post what is actually in the columns right now that you are trying to multiply?

OAP

Hi, need to be quite crafeul with how many formulas you put in a sheet.

It can make the sheet completely unusable (just grinds to a halt) even with just moderate formula usage nowhere near the capability that is advertised or woudl generally be exected from a spreadsheet system

The formulas are also much more complicated to use than Google Sheets or Excel.