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
- Please take your cell ref c8 on the below example =IF(C8<4,4,C8)
- Skandel590Copper ContributorPlease take your cell ref c8 on the below example =IF(C8<4,4,C8)
- simonewilliams1983Copper ContributorThats brilliant! Thank you so much!