Possible IF issue

[Sam Healey]

I need to create the formula for the following

If the value in cell E8 is greater than or equal to 40 then cell F8 is to equal 40, but if cell E8 is less than 40 then F8 should equal the original value of cell E8 i.e 37

Is this possible?

[#2]

Hi @Sam Healey

Try this in cell F8:

=IF(E8>=40, 40, E8)

Cheers

Damien

[#3]

Hello Sam

Simply this:

=MIN(E8,40)