Forum Discussion
DJRM72
Apr 16, 2021Copper Contributor
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...
Rajesh_Sinha
Apr 17, 2021Iron Contributor
Is this "multiply a quantity of 50 by a rate of €10 but give a cut off value of €100?" a general rule or as you have written that, "Customer D has agreement that maximum charge is €100",,, so do you have any such list? Please be specific all about CUT OFF method/mechanism ,, also edit your post & add complete information !!