Nested IF function

[SARAH11]

Hello Genius people, 

I need your help with nested IF function 

I have 4 tables and a dropdown list, I want some of the numbers from the tables to change according to the choice of the dropdown list. 

For example, if the dropdown list = 100% 

Cells: F3, G3, O3, P3, X3,Y3, AG3, AH3..  have to have certain values else, stay as they are. 

Hope I explained it clearly.. 

Thanks in advance

[#2]

Ok, I believe that the actual value in the F3 cell of Transition Matrix sheet is 0.00695 only, but that F3 cell is formatted to show only 3 decimal places, so that 0.00695 is getting rounded off to 0.007 in display. Check the formula bar of F3 cell. If it is a constant (typed) value, then see is it 0.00695? Or in case it is a calculated value.. change the format of the F3 cell to 'General' (just for checking), does it become 0.00695?

If formula doesn't change the value if the cell is just referrenced as it is like you did.
Your formula is working right as it should.

[#3]

You are a genius my friend, I am beyond grateful, I hope you know how amazing you are.

Thank you Amit

[#4]

Glad to know that it helped. Thanks.