If function

Example use case: Calculate commission in the form of 10% for 10.000€ or more turnover, and 5% for commission for turnover that is below.

=if(B3>=10000;B3*0,1;B3*0,05)

Countif

Frequency

VLookup

Finds a value in a column to the right of a search criteria, e.g. what is the ranking position for the term “wordpress” in our example.

Combine