Forum Discussion
Mima_Petrosevic
Sep 04, 2023Copper Contributor
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
- Sep 04, 2023
IF(A1>1,A1,"X")
Detlef_Lewin
Sep 04, 2023Silver Contributor
IF(A1>1,A1,"X")- Mima_PetrosevicSep 04, 2023Copper Contributor