If Greater Than Match cell. IM SURE THIS SHOULD BE SIMPLE

Hi there, pulling my hair out over this one, Im a bit of a beginner so i would appreciate help with this one.

I though this would be one of the easiest formulas on my sheet but its proving a pain in the backside.

I trying to make a cell show the value of another cell if it is over 6 if the value of the other cell is under 6 i want it to display 6. However all it keeps doing is showing what ever is in the other cell.

Here is my formula:
=IF(H46>6,H46,"6")
I just tried =IF(H46>6),H46(H46<6),6
but that does not work either

Much appreciated

Is the value a number or text? If it is text, you will need to convert it to a value to compare:

=IF(value(H46)>6,H46,"6")

or

=IF(value(H46)>6,H46,6)

HI

Thank MartinDwilson =max(h46+0,6) worked great

Thanks again