Multiplying column values?
Hi Community,
I have a sheet with section score values ("Ease Score", "Permanence Score", "Impact Score", "Cost Score") that I am trying to multiply to find an overall score ("Project Score"). Each section score column has a column formula with nested IFs to return the correct value, and I'm worried that's what is causing my "Project Score" value to return #INVALID OPERATION. Is it that? Something more simple? What am I missing?!
Best Answer

Try removing the quotes from around each of the numbers to be output. The quotes will output a text value which can't be multiplied by anything.
Answers

Can you provide the nested IF?

Sure. For "Impact Score" the nested IF is:
=IF(([Anticipated annual savings]@row) = "25K or Less", "1", IF(([Anticipated annual savings]@row) = "50K", "2", IF(([Anticipated annual savings]@row) = "75K", "3", IF(([Anticipated annual savings]@row) = "100K", "4", IF(([Anticipated annual savings]@row) = "200K", "5", IF(([Anticipated annual savings]@row) = "400K", "6", IF(([Anticipated annual savings]@row) = "500K", "7", IF(([Anticipated annual savings]@row) = "600K", "8", IF(([Anticipated annual savings]@row) = "750K", "9", IF(([Anticipated annual savings]@row) = "1M", "10"))))))))))

Try removing the quotes from around each of the numbers to be output. The quotes will output a text value which can't be multiplied by anything.

PAUL! YES! Thank you! This did the trick.

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 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!