hi there!
I have this doubt.
Look at this formula:
=IF(C1=0,””,C1)
This formula commands Excel to return nothing if cell C1 is empty; otherwise the result should be the content of cell C1.
Can I use a similar formula to command Excel to return nothing if an array formula returns "0" as the result? I mean something like this:
=IF(Array formula =0,"",Array formula)
The array formula I am using is this one:
If this is possible, I don't know what the syntax would be to write the formula, or when I should click CTL+SHIFT+ENTER to activate the array formula if it is preceeded by an "IF".
Bookmarks