Forum Discussion
Solved
How to replace value with blank
Hi, value error appears and this is the string of the cell where it appears in: =IF(C7=Sheet2!$J$3;2;IF(C7=Sheet2!$J$2;5;""))+[@[Entry date]] But I want to have it blank if it shows value...
- Hello,
What about using IFERROR function, IFERROR(IF(C7=Sheet2!$J$3;2;IF(C7=Sheet2!$J$2;5;""))+[@[Entry date]]; "")
Let me know if it helped or detail ur problem,
Best regards
As variant
=IFS( C7 = Sheet2!$J$3; 2 + [@[Entry date]];
C7 = Sheet2!$J$2; 5 + [@[Entry date]];
TRUE, "" )