Hi,
Can you use " " instead of ’ '? No big deal but could be easier to read at the end, and to be maintained.
Also you should not use “£0” etc. but 0 etc. I use pure numbers in my formula not numbers + currency
IF(AND({Purchase Price}>=0, {Purchase Price}<=50000), "£0-£50,000",
IF(AND({Purchase Price}>=50000, {Purchase Price}<=100000), "£50,000-£100,000",
IF(AND({Purchase Price}>=100000, {Purchase Price}<=200000), "£100,000-£200,000",
IF(AND({Purchase Price}>=200000, {Purchase Price}<=300000), "£200,000-£300,000",
IF(AND({Purchase Price}>=300000, {Purchase Price}<=400000), "£300,000-£400,000",
IF(AND({Purchase Price}>=400000, {Purchase Price}<=500000), "£400,000-£500,000",
IF(AND({Purchase Price}>=500000, {Purchase Price}<=650000), "£500,000-£650,000",
IF(AND({Purchase Price}>=650000, {Purchase Price}<=800000), "£650,000-£800,000",
IF(AND({Purchase Price}>=800000, {Purchase Price}<=950000), "£800,000-£950,000",
IF(AND({Purchase Price}>=950000, {Purchase Price}<=1100000), "£950,000-£1,100,000",
IF(AND({Purchase Price}>=1100000, {Purchase Price}<=100400000), "£1,100,000+",
"Out of range"
)
)
)
)
)
)
)
)
)
)
)