Forum Discussion
Writing conditional formulas
I want to compare multiple items with multiple variable and rank them using a point system. If I enter six or seven variables, I want to write a formula to give each of these a specific point value ...
Perhaps you may share manually created sample file with desired result to explain logic more precisely; and mention on which Excel version/platform you are.
Yes, you are right, that would be helpful. I am using version 2202, and I will attempt to attach a sample file for help. I made it into a car comparison chart.
Thank you . Is it critical to have texts as in A7:A12? I'd suggest to use helper tables instead and lookup on them.