Basic programming in Excel

Software & Apps
#1

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)

#2

That is how I would have done it too (actually, I use that a lot… :wink: )

Gotta love those IF functions…especially if you include many of them in 1 cell… That is what you get when you create programs for tax calculations :wink: