Formula to limit maximum value

I have a large column of data and wish to run a formula over the data which checks the value and changes it to a set value if it exceeds a certain amount.

ie. for a single field it would look like this IF(C7>50,50,) but this doesn't run over the whole column.

Thanks

Lunar