CODEWITHSUNDEEP
excelexcel-formula
M G M
M G M

Reputation: 1

Excel IF function with 3 conditions

I have three conditions if I want to join in one and I can not join them without an error. The sentence is as follows:
1. =SI(F22<7,BUSCARV(F22,B19:C24,2,FALSO),"Operación no definida")
2. =SI(F22=4,G19<>0,"No se puede realizar la operación")
3. =SI(F22=4,G19<>0,"No se puede realizar la operación")

Upvotes: 0

Views: 88

Answers (1)

Reeza
Reeza

Reputation: 21294

I think you missed an AND in your second and third conditions:

=SI(AND(F22=4,G19<>0),"No se puede realizar la operación", "NO ELSE CONDITION")

or maybe OR()?

Upvotes: 1

Related Questions