Thursday, 5 June 2025

scalc

 

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)

 

TermRecord

TermRecord is a simple terminal session recorder with easy-to-share self-contained HTML output! TermRecord -o /tmp/session.html