Forum Discussion
Solved
IF in Excel
Hello, how can I write an IF formula in excel, so that if the value in cell A1 is greater than 1, it copies that value, otherwise it writes the sign X
IF(A1>1,A1,"X")
2 Replies
IF(A1>1,A1,"X")
Hello, how can I write an IF formula in excel, so that if the value in cell A1 is greater than 1, it copies that value, otherwise it writes the sign X
IF(A1>1,A1,"X")IF(A1>1,A1,"X")