When you combine it with the IF function, it can create a more dynamic formula ... if TRUE, Value if FALSE). In cell J2, enter this formula =IF(C3>G3,A1,E1) ...
確定! 回上一頁