I'm struggling to create the correct formula for calculating commissions. If you have suggestions they would be greatly appreciated. P.S. All notes are in attached spreadsheet.
I'm struggling to create the correct formula for calculating commissions. If you have suggestions they would be greatly appreciated. P.S. All notes are in attached spreadsheet.
I have asked a question on your other post![]()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
i cant find the other post!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Maybe something here will help:
http://mcgimpsey.com/excel/variablerate.html
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
the other post is in CF, thbis is a duplicate
What's CF?![]()
oops I meant CS Commercial Services
(it was conditionally formatted (CF) to change, but I didnt apply a format lol)
only mods and admins can see that forum
Sorry guys, the FAQ clearly states to the OP not to duplicate the threads.
Thread closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks