=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)