Dec 09 2021 12:17 AM
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
Dec 09 2021 02:20 AM
SolutionDec 09 2021 02:46 AM
As variant
=IFS( C7 = Sheet2!$J$3; 2 + [@[Entry date]];
C7 = Sheet2!$J$2; 5 + [@[Entry date]];
TRUE, "" )
Dec 09 2021 02:20 AM
Solution