nested If multiple conditions and multiple columns

Question

I am trying to nest conditional statements involving multiple columns. How can I write in cell (g2) if B2=100 give me the value in e2, and only if B2 is less than 100 check if C2 is greater than 26.67, if it is give me the value in F2; but if neither condition is met return -9.

I typed the following: =IF(IF(B4=100,E4),(IF(C4>=26.67,F4)),"-9") and it worked for the most part but the problem comes when one condition is met but not the other one (i.e. B2=100 but C2 is not greater than 26.67 it returns FALSE; but if either condition is met I would like to get a value either from E2 or F2 but the formula seems to understand that i am asking for both requirements... please help!!

Thanks in advance

Answer 1

You are welcome.

Answer 2

Hi,

Try this

=if(B2=100,E4,if(and(B2<100,C2>26.67),F2,"Do something else"))

Answer 3

Thank you so much!! It worked perfectly!