Excel formula for "maximum value"

[david33957]

I have a simple calculation with a twist -- I need to get a maximum value.

Price per unit is $50, but only up to a maximum of 8 units. From 8-20, the maximum total price is $400.

How do I get that result?

Thanks for any help.

David

[shg]

Perhaps =MIN(qty, 8) * 50

[david33957]

Thanks for the suggestion. I'm not sure what do with this formula.

Currently, I have this in the cell: =H6*50

I appreciate your help.

David

[shg]

Maybe =MIN(H6, 8) * 50