What am I doing wrong
I am using this formula in cell E7 successfully =IF(D7-C7<0, 1+D7-C7, D7-C7).
But when cell C7 has no data I do NOT want ‘0’ to appear in E7. I have tried various formulas including this one =IF(C7=””,””,D7-C7<0, 1+D7-C7, D7-C7) but it doesn’t work.
Can someone please...