[Help] Excel MIN Function

Question

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!

hansvogelaar · Answer

bensonsuen&nbsp;
Let's say the number of customers is in C1.
&nbsp;
=MIN(C1,100)*10000

bensonsuen · Answer

HansVogelaar&nbsp;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?

hansvogelaar · Answer

bensonsuen&nbsp;
That is what the formula does - try it!

bensonsuen · Answer

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

Forum Discussion

[Help] Excel MIN Function

4 Replies

Resources