I'm hoping someon can help me with this, as I'm starting to crazy
In my spreadsheet I have two drop down lists created.
One has the variables 0%, 2%, 5%, 7.5%
and the other has: 90-99,95-105,100 - 109
Basically if it shows :
0% AND 90-99% I want it to show x, if it shows 0% AND 95-109 show y, if it shows 5% and 100-109 show z
Then the same for the other percentages, so 2% and the above 3 variables, 5% and the above 3 variables, 7.5% and above 3 variables
The formula I currently have is....
=IF(AND($C$10="2.0%",B14="90% - 99%"),'SA Scenarios'!B75,IF(AND($C$10="5.0%",B14="90% - 99%"),'SA Scenarios'!B100,IF(AND(B14="90% - 99%",$C$10="7.5%"),'SA Scenarios'!B124,IF(AND($C$10="0.0%",B14="90% - 99%"),'SA Scenarios'!B50,FALSE))))
As you can see this only works if the second drop down is 90-99
basically I want it to do this:
=IF(AND($C$10="2.0%",B14="90% - 99%" 'SA Scenarios'!B75 OR IF c10=2.0% AND B14=95-105, 'SA Scenarios'!B76, OR IF c10=2.0% AND B14=100-109%, 'SA Scenarios'!B77....etc etc....starting again with the 5% and 7.5% possibilities...
Hope this makes sense - grateful for any help
Bookmarks