How to replace value with blank

New Contributor



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 (New Contributor)

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, "" )