If...and

http://www.excelforum.com/showthread.php?t=631606

=IF(D37=1,Q29,IF(D37=2,R29,IF(D37=3,S29,IF(D37=4,T29))))

Following on from this thread and formula that I was very kindly given help on.

I now want it to be expanded so that if another cell equals a certain value regardless of what D37 equals, it puts in some text. Kind of like an overide.

I tried the following, which worked.
=IF(AND(D37=1,D35<=1500),Q29,"Spot Quote")


I then tried to add additonal IF's (below), and it did not work. I understand why, as it contradicts itself. But I am stuck on what to do next.

=IF(AND(D37=1,D35<=1500),Q29,Spot Quote)IF(AND(D37=2,D35<1500),R29,Spot Quote))