Putting values in a catagory

Hi all,

I have 3 cost bands/categories, they are as follows:-

<£50,000 Minor
£50,000 - £1M Medium
>£1M Major

How do I get this to calculate the values and return a Minor, Medium or Major in the cell adjacent?


cost Category

£218,691.21 ?
£741,243.91 ?
£218,691.21 ?
£244,405.49 ?
£293,977.21 ?
£107,994.43 ?

Thanks in advance.

D

Originally Posted by Olly

Try:

Formula:

Please Login or Register  to view this content.

Great thanks