I have two colums and a function which returns the sum of several cells. For example D6-C6. Now, there are times when these are left blank, and then excel displays “0” in my result-cell. Which is annoying. I dont want it to display anything, if there is nothing to display, using IF-stuff (I suppose?).
How do I get Excel to leave a cell blank if there is nothing to calculate?
Fixed it with IF(D6-C6=0;"";D6-C6)