Using =if? with a number range

[finnbrit]

Hi all,

Thank you for the help I received last time I posted. If you could offer such great support again then I'd much appreciate it!

How do I create a formula that will evaluate a number range and post an answer?

Points range	Outcome
0-74	Pass
75-149	Merit
150+	Distinction

So, what I'm after is a formula that, if confronted with the number 72 will say 'Pass', if confronted with the number 101 will say 'Merit', and if confronted with the number 162 will say 'Distinction'.

Any help would be very gratefully received!

Thanks in advance!

[AlKey]

Try this

Please Login or Register  to view this content.

[Tony Valko]

One way...

A1 = some number value

=LOOKUP(A1,{0,75,150},{"Pass","Merit","Distinction"})