"Invalid Operation

Shannon Lacerda

Why am I getting and "Invalid Operation on a simple formula that I have used many times

Shannon Lacerda

Thank you that worked, but for some reason the column wont switch to a %, so I just made a helper column one with the % and one for the formula that I will hide.

Jason Albrecht

Hi Shannon,

I'm not sure if the formula is looking to sum the two, or multiply?

If Sum, I'd try

=SUM([Structure Value]@row, [Win Prob %]@row)

If multiply, I'd try

= [Structure Value]@row * [Win Prob %]@row

Hope this helps?

Shannon Lacerda

The formula seems to be correct as it works on other sheets, I can seem to figure out what is wrong with this particular sheet

Genevieve P.

Hi @Shannon Lacerda

This error can occur if the formula is reading one of the cells as text instead of numerical. How is your percentage calculated? Can you paste that formula here?

Try wrapping a VALUE function around one or both cells:

= VALUE([Structure Value]@row) * VALUE([Win Prob %]@row)

Shannon Lacerda

@Genevieve P.

I tried the VALUE, I get the #INVALID VALUE

Below is how I get my %, I think this is the issue, I tried a dummy colum and manually entered the % and it works. But I need it to work from the {Win Proability %} column

Genevieve P.

HI @Shannon Lacerda

Yes, this is exactly where the issue is coming from. Using "11%" in your formula tells the cell that 11% is a text value.

Try using the decimal value instead, like so:

=IF(Rank@row = "B", 0.11

Then you can add the % formatting to the entire column from the top toolbar instead. Let me know if this works!

Cheers,

Genevieve

Shannon Lacerda

Thank you that worked, but for some reason the column wont switch to a %, so I just made a helper column one with the % and one for the formula that I will hide.