=IF(AND(NOT(A2>1),NOT(A2<100)),A2,"The value is out of range"). 50 is greater than 1 (TRUE), AND 50 is less than 100 (TRUE), so NOT reverses both arguments to ...
確定! 回上一頁