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.
I don't understand the last two items of the 'Pay to nurse' list.
HansVogelaar Hey Hans just wondering if you needed more clarification on this. I could really use the help on this. I feel like it's some type of layered if(s) statement but every example I find for that is totally different.
- 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
