I have a very similar problem to Art.
In my case the problem arises when my 1-2-3 sheet is saved as an Excel sheet
and then I get a heap of #VALUE! results in Excel.
The reason for this is because the 1-2-3 formulas contain a lot of ""s,
which is text and can only be added by Excel using =sum, or so I understood.
Unfortunately, =sum does not work when several non-contiguous cells are added
and the "" cell is deducted.
Example: =SUM(A1;B1;-C1) where C1 contains "" (as a result of a condition
not having been met in C1). The =sum formula shows #VALUE! only because the
What do I have to put in my C1 formula so that, when the condition there is
not met, it shows nothing and does not cause a #VALUE! elsewhere? C1 is not
allowed to show zero because that is an incorrect value.
What is the best solution?