SOLVED

How to replace value with blank

Copper Contributor

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

Zrzut ekranu 2021-12-09 091639.png

2 Replies
best response confirmed by Ramon625 (Copper Contributor)
Solution
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

@Ramon625 

As variant

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

Accepted Solutions
best response confirmed by Ramon625 (Copper Contributor)
Solution
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

View solution in original post