Forum Discussion
simonewilliams1983
Apr 02, 2024Copper Contributor
IF Formula
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
- Apr 02, 2024Please take your cell ref c8 on the below example =IF(C8<4,4,C8)
Skandel590
Apr 02, 2024MCT
Please take your cell ref c8 on the below example =IF(C8<4,4,C8)
simonewilliams1983
Apr 02, 2024Copper Contributor
Thats brilliant! Thank you so much!