Range Lookup

[JBrE]

Hi Everyone

How can I lookup the following:

Calls £
1-5 2.50
6-10 2.00
10+ 1.75

For example, if I make 7 calls it will cost £2.00.

How formula can I use to look up and give me the answer?

Many thanks
Johnny

 

[Smitty]

Welcome to the Board!

You can create a Lookup Table.

HTH,

 

[JBrE]

Thanks Smitty