Lesser of 2 values with a cap?

[Rick-O-Shay]

Hi

I am trying to make a formula that does the following in C1:

Display the lesser value A1 or B1. But if the value is over 500,000 the vaule displayed is only 500,000.

An example would be:

A1: 579,000
B1: 600,000
C1 should show 500,000

or

A1: 650,000
B1: 425,000
C1 should show 425,000

[Mazzaropi]

Try this: =IF(MIN(A1:B1)>500000,500000,MIN(A1:B1))

[FDibbins]

or a slightly shorter version....
=MIN(A1:B1,500000)

[Mazzaropi]

FDibbins option is a BETTER indication!