Multiple IF functions

[SSharma9]

Hi all,

I am trying to create a formula that feeds off another cell which is the sum of the row.

Where the total is between 0-9, the outcome should be 'Low'. Where the total is between 10-18, the outcome should be 'Medium'. Where the total is between 19-26, the outcome should be 'High'.

Please help!

Thanks,

[63falcondude]

Hello and welcome to the forum.

If your "another cell" is A1, try this:

=LOOKUP(A1,{0,10,19},{"Low","Medium","High"})

If it is possible for the sum to be greater than 26 and you want to return something else for that scenario, that would look like this:

=LOOKUP(A1,{0,10,19,27},{"Low","Medium","High","something else"})

[mehmetcik]

Please Login or Register  to view this content.