Hi
I'm trying to add either a new condition to a formula or modify existing formula, so blank cells can't be taken as a number like 0
Here is the formula =IF(N14>0,1,0)
***This is what I do with formulas with similar problems =IF(COUNT(Y14,A14)=2,Y14/A14*100,"") unfortunately the above condition its already a condition by itself so I don't know what to do whether to modify condition or add a new condition which I don't know how to do.
Thank you very much![]()
Frank
Bookmarks