Forum Discussion

SARAH11's avatar
SARAH11
Brass Contributor
Nov 01, 2020
Solved

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 cel...
excel
  • amit_bhola's avatar
    amit_bhola
    Nov 01, 2020

    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)))

     

     

SARAH11's avatar
SARAH11
Brass Contributor
Nov 03, 2020

amit_bhola Dear Amit, 

I appreciate all your effort and everything you offered for the past few days. 

Since separating them would be a hustle then 20 numbers on the dropdown list doesn't sound too bad. 

 

I'm beyond thankful and grateful. 

Wish you all the best in your life.

It was nice and easy communicating with you. 

 

Thank you for being super helpful. and thank you for being a great and amazing human being.

amit_bhola's avatar
amit_bhola
Iron Contributor
Nov 03, 2020

SARAH11 , My pleasure, Thanks for your wishes. Communication is two way and you were also patient with conversation. All the best!

Resources