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?(https://i.stack.imgur.com/lyzw2.jpg)

Tags : google-sheets


Related Questions




Copying values between google sheets

Updated July 26, 2018 21:03 PM