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 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
- 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.
22 Replies
- Select F3, G3, O3, P3, X3,Y3, AG3, AH3... then apply the formula
=IF(CellWithTheValueFromDropDownList=100%,"PutTheValueYouWant","Stay_As_It_is")
