Hello,
I am having trouble with a simple IF formula. Please see attached file with my data. I made the cell where I am having trouble with the formula in yellow.
If the cell in column C is empty I would like my formula in F column to stop summing and return "" or space or "-", but if there is a value in column C it should do the sum, just like in the formulas above it. I would add this formula in all cells in col F of course (except the first cell).
I think that normally the formula should look like this:
{ =IF (C10="";"";F9+C10-D10) }
but I also tried this
{ IF (C10="";"";F9+C10-D10) }
and this:
{ IF C10="" "" F9+C10-D10 }
and this:
{ IF (C10)="" "" (F9+C10-D10) }
and this:
{ IF {C10}="" "" {F9+C10-D10} }
They either show a blank result when it should be a sum, or they show "Syntax error".
My regional settings are with semicolon, but I also tried with comma and got the same results.
I've tried several others I can't even remember anymore, to no avail.
I hope this is possible and someone can help me.
Bookmarks