Forum Discussion
Multiplication and cut-off value
Hi all, I am trying to complete a table of suppliers on Excel Windows 10. Some suppliers have a cut-off cost of €100. So is there a formula that would multiply a quantity of 50 by a rate of €10 bu...
Since there is nothing specific to work on, a general idea might be
= LET(
cost, quantity*rate,
if(cost<threshold,cost,threshold) If you are not using Excel 365 just calculate the cost twice within the final formula. If the cost and quantity are scalars rather than arrays, you could use MAX/MIN depending on whether the cut-off is an upper or lower limit.
PeterBartholomew1 Thank you, that seems to work. Is it possible to limit the cut-off to particular rows - Supplier D in the attached example?
- Perfect! Thank you very much.
