Here is my dilemma.
I offer customers terms to process circuit boards and I have a spreadsheet that calculates what the estimated value will be and and also factors in charges and metal deductions.
For gold, we pay 95% of the gold weight OR 0.5ozt per 2000 lbs. of weight received, whichever is greater.
F29 is the total weight received.
J33 is the value of 5% (this can change occasionally, so I need a formula that references this cell for the % value so I can plug in different %'s)
I have attached an example of what I'm trying to do more precisely. Thanks in advance for any help getting this solved.
Bookmarks