Forum Discussion
Layered If Statement
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.
13 Replies
Please provide some detailed, specific examples of what you're trying to do.
I don't understand the last two items of the 'Pay to nurse' list.
- ok so I own an aesthetic studio that sells semaglutide and tirzepatide both are weight loss shots. We also sell botox. we pay the nurse who administers them 30% we pay the medical director 10% for each and then we have to pay for the supplies. I have a spreadsheet that lists each treatment I would like excel to calculate what we owe to the nurse, what we owe to the medical director and what is leftover. but I cant figure out how to get it to calculate differently based on what the product is
