Forum Discussion
Luke_Thom1
Oct 12, 2022Copper Contributor
Need help with a formula
I need a formula that takes volumes and calculates the cost based on volume requirements and discount per separate cells: This is the formula that I have been working off of, not working though ...
HansVogelaar
Oct 13, 2022MVP
The first one might be
=MIN(C35, 1200)*E35
The second one is confusing. Perhaps
=MAX(C35-1200, 0)*E3
or
=MAX(MIN(C35, 3600)-1200, 0)*E35