Libre Office
If/Else statement:
- If D6 value is __ then. =IF(D6>=0.2,1, IF(D6<=-0.2,-1, IF(D6>-0.2,0, IF(D6<0.2,0))))
- Calculate days from L10 cell. =if(L10,"na",days(TODAY(),A10))
Iferror statement on division by 0: =iferror(your formula;0)
- eg: =IFERROR(SUM((K22+L22)/C22)*100),0)