=SUM(A1:A10)=AVERAGE(B1:B10) =COUNT(C1:C10) =IF(D1>10, "High", "Low")=AND(E1>5, E2<10) =OR(F1="Yes", F2="No") =VLOOKUP(G1, H1:I10, 2, FALSE) =HLOOKUP(G1, H1:J10, 2, FALSE) =CONCATENATE("Hello", " ", "World") =LEFT(A1, 5) =RIGHT(A1, 3) =MID(A1, 2, 4) =PMT(rate, nper, pv)