I need to figure our how to write the correct IF formula for a cell that has multiple arguments/factors involved. I'll do my best to explain the arguments step by step below. Keep in mind this is only one portion of the whole commissions structure, so a rep would never actually owe the company money for discounting these packages. I have attached the spreadsheet that I've started. Essentially, I'd like to figure out how to combine the results in columns "P" & "Q" on worksheet "Sales" into one column.
Package A: $99.00
If you collect from the customer the full $99 you get a $15 commission
If you collection more than the $99, you get the $15 + anything above and beyond the $99.
If you collect less than the $99, you owe the difference. Example:you only collect $49, you owe the difference of $50 back to the company.
If the customers credit score is 725 + and you discount the $99, you are only 50% of the difference. Example: You only collect $49 and the customer has a credit score of 725+, you would only owe the difference of $25.
Thank you in advance with any assistance you can offer!
Select Blank Sales Spreadsheet.xlsx
Bookmarks