Forum Discussion
bensonsuen
Feb 10, 2021Copper Contributor
[Help] Excel MIN Function
The question require to find the total cost. Company will charge the first 100 customers a variable cost $10,000 and start from number 101 do not need to charge. If there is 130 customers, How ca...
HansVogelaar
Feb 10, 2021MVP
bensonsuen
Feb 10, 2021Copper Contributor
HansVogelaar thank you for your help. But if the customer is 95? Can I still get the answer which is 95*10000 instead of 100*10000?
- HansVogelaarFeb 10, 2021MVP
That is what the formula does - try it!
- bensonsuenFeb 10, 2021Copper ContributorThank you so much. I will try it later. Thanksss!