kmx.io/prism.js/examples/prism-excel-formula.html

• Show log

  Commit

• Hash : bf4f7bfa
  Author :
  Date : 2020-03-10T14:59:46
  

  Added support for Excel formula (#2219) This adds support for Excel's formula terms.

Download

• examples/prism-excel-formula.html

• <h2>Full example</h2>
  <pre><code>=SUM(G7*9)
  =INT(RAND()*999)
  =AVERAGE(A4:A13)+N("Average user rating")
  =CONCATENATE(F4, ",", " ", G4," ",H4)
  =IF($A4>500, $A4, 0)
  =AND($B4>=501,$C4&lt;=500)
  =SUBTOTAL(103,staff[Name])
  =TRIMMEAN(staff[Salary],10%)
  =SUM([Sales.xlsx]Jan!B2:B5)</code></pre>
  

Download