Forum Discussion

Copper Contributor

Dec 09, 2021

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. How can I do this?

attached also the screen

Formulas and Functions

melissa95
Dec 09, 2021
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

2 Replies

Diamond Contributor

As variant

=IFS( C7 = Sheet2!$J$3; 2 + [@[Entry date]];
      C7 = Sheet2!$J$2; 5 + [@[Entry date]];
      TRUE, "" )

melissa95
Copper Contributor
Dec 09, 2021
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

Resources