Formula for If/or required please

I would like to know if there is a formula that will achieve 2 things for me.
Cell A1 is where an amount is entered and shows in cell A2, I want the amount in cell A2 to show either an amount less than $75.00 or lower depending on the entry. If the amount entered was more than $75.00 than I would like the formula to show a maximum amount of $75.00

Is this achievable? I would so appreciate any help on this please.

Rabetz

Hi there

Here you go

=MIN(A1,75)

Hope this helps

Sorry

Thank you Jon it didn't help me but I did work out a formula to do the trick and it worked like this

=IF(A1<75,A1,75)

I appreciate your assistance

Rabetz