File: prism-excel-formula.html

package info (click to toggle)
node-prismjs 1.30.0%2Bdfsg%2B~1.26.5-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 19,220 kB
  • sloc: javascript: 27,628; makefile: 9; sh: 7; awk: 4
file content (10 lines) | stat: -rw-r--r-- 286 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
 
<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>