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 th...
Please provide some detailed, specific examples of what you're trying to do.
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