Forum Discussion
Multiple IF Function
Hello everyone
I have an urgent question that I couldn't find an answer to
I am trying to use 2 IF statements at the same time, each one contains if true value and if false value however the cells for true and false values are different
All the formulas I found contains the true value only.
Your advice is much appreciated.
This is what I am trying to do: however, didn't work
Thank you
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)))
41 Replies
- Using 2 or more IF functions together means that you need to write formula such that the 2nd IF formula written either in the TRUE result or the FALSE result of the 1st IF formula, ie, either at place for [value if true] or at the place of [value if false].
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 :-
