I have this formula IF(D25=0,“No Report”,"") in cell I25
but if I delete the 0 it still says “No Report” If I now put a space character in the cell D25 or a different number I25 clears.
Can someone suggest a formula which shows “No Report” only if 0 in D25 please?