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
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
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