Please add column H with reductions $3 and $1 and try in P9 and copy down:Formula:
=IF(O9="","",LET(m,MATCH(O9,$A$9:$A$17),INDEX($G$9:$G$17,m)*O9-INDEX($H$9:$H$17,m)))
And delete helper columns Q, R and S
Question: Your formula didn't do any calculations with Quantity yet? Isn't that important?
If you actually bothered to read the thread, you'd see this was already addressed way back in post #3Originally Posted by HansDouwe
"I'll leave it to you to sum the payout and multiply it by the quantity (if you want that) and put any headings etc. for the adjustment"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks