Creating an IF ELSEIF function in a Google sheet


I had to add values to a Google sheet depending on a list of others. (In my case I wanted to add salary ranges depending on the role of an employee). Of course this could be done with a large and nested if function but to be honest this really sucks.

After some research I found the nice filter functions that solved all my problems:

=FILTER({ListOf Values};{FilterCriteria})

In my case

=FILTER(‚Salary ranges‘!$B$2:$B$6;‚Salary ranges‘!A$2:A$6 = B2)

Where Salary ranges was the sheet that has in col A the names of the roles and in column B the range of that role and in the example B2 in the role of the current employee.

GD Star Rating

Kommentar verfassen

This site uses Akismet to reduce spam. Learn how your comment data is processed.