A.I.M. Users Bulletin Board

[Conrad]

Problem is solved!

With the automatic translation of an English Excel to a Dutch Excel one this happens:



The problem that now remains is captured in the question I asked.
When the Cell in which a number for a calculation ought to appear is EMPTY the calculation goes haywire.

In the example I have made Cell B12 empty and the entire spread becomes useless because the calculation has no element that it needs.

So this function is not useful if one downloads data list and there is a missing number in it.

So the question becomes: "IF it is useless for the case that Cell B12 is empty, why is that statement formulated that way for Cell B12?

I would make more sense to have the empty cell be filled with a 0 so that one can see right away what is happening and you can fill it with the price B11 . .

Or even better. . .have this dome automatically:

=IF(B12=EMPTY,B12=B11,Calculation). . .

or something like that so that B12 is aromatically filled with the value of B11. . .you get the idea.
IF NOT: THEN at least I GOT IT