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)))
In screenshot shared, the 1st IF formula does not have the 2nd IF formula written at either of these 2 places (arguments).
Note that the formula inputs and results (arguments) should be separated by commas but a semicolon is visible after H30.
Nested IF should be like below:-
=IF(condition 1, result if condition 1 is true, IF(condition 2, result if condition 2 is true, result if condition 2 is false))
Pls try to form the formula again.
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
