Forum Discussion
Multiple IF Function
SARAH11 , i think for the False False row, you meant "Result false value of condition 2"
Pls. see if below formula is giving the expected results or not.. and i hope you would catch how this formula is made with use of AND to check the 2 conditions simultaneously, and so if some adjustment of results is required, you can do..
=IF(AND(G20=0,J20=1),0.35,IF(AND(G20=0,NOT(J20=1)),F30/(F30+G30),IF(AND(NOT(G20=0),J20=1),H30,I30)))
Thank you so much for your valuable time amit_bhola
However when I applied the formula you suggested it got messy as it used the first condition to give the second true result . so when I changed the first condition from 1 to 0, it gave me the result when the second condition changed from 3 to 2. hope there is a solution for this obstacle.
SARAH11 , are you trying to write a formula like below table pattern? If so, then can you write the conditions and required results in yellow cells and send back. This kind of pattern requires use of AND formula inside IF formula.
Example sharing of what you are trying to do. Pls. make a table and send :-
If Condition 1 If condition 2 Then Result True True Result true value of condition 2 True False Result true value of condition 1 False True Result false value of condition 1 False False Result false value of condition 1 This also worked with a slight change
=IF( G20=0,IF(J20=1,0.35,F30/(F30+G30)),H30)
Thank you so much appreciate it
SARAH11 , i think for the False False row, you meant "Result false value of condition 2"
Pls. see if below formula is giving the expected results or not.. and i hope you would catch how this formula is made with use of AND to check the 2 conditions simultaneously, and so if some adjustment of results is required, you can do..
=IF(AND(G20=0,J20=1),0.35,IF(AND(G20=0,NOT(J20=1)),F30/(F30+G30),IF(AND(NOT(G20=0),J20=1),H30,I30)))=IF(AND(G20=0,J20=1),0.25,IF(AND(G20=0,NOT(J20=1)),F30/(F30+G30),IF(AND(NOT(G20=0),J20=1),H30,I30)))
I made a slight change that is bold, otherwise it work yaaaaaay you are the hero of my day
I cant thank you enough
Million thanks to you I really appreciate your time and effort
