= if certain amount or less than formula

[biglb79]

is there a formula where I can have the number in column G equal the number in column F, but it would cap off at $500? for example if column F is $415 then G needs to be $415, but if F is $620 then G needs to be $500

Thanks

 

[steve the fish]

You can use MIN

=MIN(500,F1)

then if F1 is greater then 500 it just shows 500.