I currently have a spreadsheet that figures commissions based on one of two factors.
1. Mono-line commissions
2. Multi-line commissions
I want to add, if possible, a way to divide the commission by 2 if it is a shared commission.
This is the formula that I am using...