VLOOKUP by ranges
Find which range a value falls into.
Think of a "buy more, pay less" deal: from 10 units there's a 5% discount, from 50 it's 10%, and so on.
Module: Looking up information. Lesson 22 of 62.
Find which range a value falls into.
Think of a "buy more, pay less" deal: from 10 units there's a 5% discount, from 50 it's 10%, and so on.
Module: Looking up information. Lesson 22 of 62.