11 lines
286 B
HTML
11 lines
286 B
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<=500)
|
|
=SUBTOTAL(103,staff[Name])
|
|
=TRIMMEAN(staff[Salary],10%)
|
|
=SUM([Sales.xlsx]Jan!B2:B5)</code></pre>
|