Conditional choices from a list

by LJB   Last Updated September 12, 2018 20:03 PM

I have 8 different fee rates in a spread sheet. Only one will be chosen from the list. I want to find a total of various fees that includes one of these. Is there a way to right a conditional without nesting 8 different IF statements?Depending on job musicians get paid one of the amounts on left. There are then other expenses in the spread sheet and I want to get s total of all expenses. How do I indicate in formula to use the appropriate musician fee?(

Tags : google-sheets

Related Questions

Copying values between google sheets

Updated July 26, 2018 21:03 PM