Number range word

[K-Linerz]

Hi I have a range of number from 0 to over however many it goes to. (No limit)

I need a formula so that if the number in the column is less than 50 it gives me the word "new", if its between 51 and 100 then its "old" and if its over 100 then it needs to say "Aged"

Can you tell me the best formula?

Many Thanks

[BadlySpelledBuoy]

One way:

Please Login or Register  to view this content.

Change A1 to suit your data

You can wrap it in IFERROR to take account of blank cells if that's required.

Please Login or Register  to view this content.

BSB

[AlKey]

Try this

Please Login or Register  to view this content.

v	A	B
1	50	New
2	60	Old
3	70	Old
4	10	New
5	42	New
6	102	Aged

[Kevin#]

if your first value is in cell A2, put this formula in B2 and copy&paste down columnB

Please Login or Register  to view this content.