Formula Question: IF, OR, AND Solution Maybe? Nested? Other Logic?
What formula would work when a certain answer is selected in Column A, its result would be 10%. If that selection in Column A holds true and you select a certain answer in Column B the return value is 20%. Until you have certain answers selected in Columns C, D, E, F and G, you have 30%, 40%, 60%, 80% and 100% respectively as returns.