So, I have values in cell F2, and I want G2 to return the value in F2 but cap the returned value at 10, and also if there is an error in cell F2, I need the returned value to be 0.
I tried =IFERROR((IF(F2>10,10,F2)),0) but that just returns "FALSE" no matter the value in F2.
Bookmarks