=IF(AND(N5>4999,N5<6000),"BUSINESS","PERSONAL")

The statement should read as follows:

If the value in N5 is between 5000 and 5999, return the value ** Business, otherwise return the value ** Personal.

This functional statement does not work. Why?

Thanks for your help