IF Formula

[simonewilliams1983]

Hi

Can someone please help.  How do i do this

If a cell is < 4 then return 4 but if a cell is > than 4 then return the number that is in that cell

[#2 · Accepted solution]

Please take your cell ref c8 on the below example =IF(C8<4,4,C8)

[#3]

Thats brilliant! Thank you so much!