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

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.
Answers

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?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile  Open to work

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

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)

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

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

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.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!