Feb 10 2021 08:03 AM
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 can I use MIN function to calculate the total cost?
thank you!
Feb 10 2021 08:25 AM
Feb 10 2021 08:31 AM
@Hans Vogelaar 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?
Feb 10 2021 08:35 AM
That is what the formula does - try it!
Feb 10 2021 08:40 AM