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.
I forgot to mention that I have 4 percentage: 100%, 75%, 50% and 25% in the dropdown list. every percent incur different cells numbers
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.
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.
- Amit.. you are smart.. It worked perfectly..
It would be extra awesome if you can help me with the following...
lets assume that the probability for patients having surgery = 0.007
and the probability of the new medication to lead patients to do the surgery is 75% less.. then will test if the probability is 50% and 25% less... Is it possible to provide me with the new probabilities of the different percentages?
Thank you- I added 0 to the dropdown list to allow the value to stay as it is, but when I choose zero it gave me complete different number !.
My formula is :
=IF(N10=25%,AT3,IF(N10=50%,AQ3,IF(N10=75%,AN3,IF(N10=100%,0,'Transition matrix'!F3))))- As per the formula, for anything other than 25%,50%,75%,100% in cell N10, the output should be same as value in cell F3 of sheet Transition matrix. Is output not so? Are you sure the format of cell F3 of sheet Transition matrix is same as the formula cell? (And just checking, is the cell F3.. holding the as-it-is value that you desire to be outputted for zero at N10?)