Forum Discussion
Solved
Nested IF function
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 ...
- Suppose,
value for ....is
as it is= 5
25% = 125
50% = 150
75% = 175
100% = 200
and the drop-down list is in cell A1, then the required formula could be
=IF(A1=0.25,125,IF(A1=0.5,150,IF(A1=0.75,175,IF(A1=1,200,5))))
Note that the "as it is" value (5) needs to be hard coded into the formula. And effectively it (5) shall be displayed only when the A1 cell is empty.
Hope that that's what you intended and the formula works as such.
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.
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.
You are a genius my friend, I am beyond grateful, I hope you know how amazing you are.
Thank you Amit
Thank you Amit
- Glad to know that it helped. Thanks.