I'm trying to achieve the following in LibreOffice (did it with Excel already, but importing this excel-created file produces the same error). I have 3 columns
(A) (B) (C)
ECTS Mark Done-ECTS
3 4 3
3 Err 518
2 2 2
So I want to calculate how much ECTS I have achieved so far. The Formula for the Done-ECTS Column is the following: =IF(ISBLANK(B2) , ,A2); So IF the Mark is empty (not done yet), show nothing. If I already have a mark, display the ECTS. I can't insert something like "" because I make a sum of my Done-ECTS, and "" resolves in an #Value error.
Is there a workaround?