I'm trying to get the following formula to function.. and as it's setup the final [false] parameter keeps showing up, as IF it's ignoring the rest of the IF statement.
The formula is to pull a title based on an inputted rate, where rates 6 and 7 have multiple titles. I would like the specified title presented when there is only one choice and a drop down for title selection when there are two choices for a single rate.
A32:A41 are titles and B32:B41 are rates.
Cell A66 contains the test "No Valid Rate Selection". When I use data validation to handle the formula, I am ONLY returned whatever is the final FALSE, in this case the contents of A66, not any other of the possible titles.
=IF(B7="RATE1",A33,IF(B7="RATE2",A34,IF(B7="RATE3",A35,IF(B7=”RATE4”,A36, IF(B7=”RATE5”,A41, IF(B7="RATE6",INDIRECT(Rate_150),IF(B7="RATE7",INDIRECT(Rate_135),A66)))))))