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)))
| 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 |
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
SARAH11 , yeah i noted later.. did you mean the bold text = 0.35 instead of 0.25 ? pls. check.. in screenshot, it was 0.35... (it seems to be the typo day today but never mind...) Thanks!