I have a basic question. I sell a few different products and then other employees receive a portion of the sales from that product but they are paid out differently depending on the product. so on the spreadsheet I have a list of the products and would like it to calculate the payout based on which product it was. So in one column I have the products in a dropdown format and then I have 3 other columns with each individual person who will be paid out on the products. I’ve looked into doing an IFS statement and a layered statement but none of them seem to do what I’m hoping. What do I need to do for this.

​I have a basic question. I sell a few different products and then other employees receive a portion of the sales from that product but they are paid out differently depending on the product. so on the spreadsheet I have a list of the products and would like it to calculate the payout based on which product it was. So in one column I have the products in a dropdown format and then I have 3 other columns with each individual person who will be paid out on the products. I’ve looked into doing an IFS statement and a layered statement but none of them seem to do what I’m hoping. What do I need to do for this.  Read More

​