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
Bookmarks