Setting a MAX on my Formula

[kcrudo]

We have a Short-Term Disability program that pays 60% of their weekly wages to a maximum of $400.00.

I need to audit my statement and wanted to make this caculation. My current formula reads:

=sum(WKWAGE*0.60)

What would I need to add to keep the Maximum number to $400.00?

Thanking you in advance.

 

[IML]

You can use
=MIN(400,wkwage*0.6)

no need to sum here, as far as I can see.

 

[kcrudo]

It Worked!

I'd buy you a beer if you were closer!
Thank you kindly.

I wish there was a formula
class I could take. :wink:

TY!