Combining two IF statements

[vostroxe]

=IF(AND(C1<>"B",B1<0),50,40)

=IF(AND(C1="B",B1<0),40,50)

Urgently need guide on how to combine above two IF statements into one.

 

[ttray33y]

What if B1 is GREATER than 0 and C1 = "B"?

 

[vostroxe]

What if B1 is GREATER than 0 and C1 = "B"?

The result will be "50"

 

[ttray33y]

The result will be "50"

Nest your other IF to the other one, like this:

=IF(AND(C1<>"B",B1<0),50,IF(AND(C1="B",B1<0),40,50))

 

[fhqwgads]

i think it's like
=IF(testA, result if A is true, result if A is false)
=IF(testB, result if B is true, result if B is false)
=IF(testA, result if A is true, IF(testB, result if B is true, result if A and B are false))

i'm cant tell if your code has a result for if neither is true but think combining your code might look like

=IF(AND(C1<>"B",B1<0),50,IF(AND(C1="B",B1<0),40,"result if neither is true"))

sorry if i've made things more confusing. i might be wrong about some stuff. i'm on excel 2007 but i think 365 has a the function =IFS() which might be more helpful but i dont know much about it

 

[ttray33y]

Thats why I asked the poster @ post #2 .

 

[fhqwgads]

sorry i am incredibly slow at typing

 

[jtakw]

Hi,

=IF(B1<0,IF(C1=“B”,40,50),IF(C1=“B”,50,40))

Did this on my phone, do not copy and paste, re-type the formula in Excel.

 

[vostroxe]

Hi,

=IF(B1<0,IF(C1=“B”,40,50),IF(C1=“B”,50,40))

Did this on my phone, do not copy and paste, re-type the formula in Excel.

It worked. thanks to all of you.

 

[jtakw]

You're welcome.