[Help] Excel MIN Function

Copper Contributor

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!

4 Replies

@bensonsuen 

Let's say the number of customers is in C1.

 

=MIN(C1,100)*10000

@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?

@bensonsuen 

That is what the formula does - try it!

Thank you so much. I will try it later. Thanksss!