Forum Discussion
Calculating revenue split with caps
Hi all. Been trying to crack this problem for a few hours but struggling. Hopefully someone can point me in the right direction. I'm trying to calculate the revenue split between two partners, ...
See the attached workbook.
Many thanks for this! Worked a charm.
Its an elegant solution, and need to work through it to fully understand the logic and syntax you used.
I might come back for some clarifications (if you don't mind) as I am really keen to add to my toolbox, but meantime I really appreciate the solution.
Cheers - red_line
Feel free to ask more questions!
