# Is it possible to combine two IFS functions in one?

Occasional Contributor

# Is it possible to combine two IFS functions in one?

Hi!

I'm tring to combine these two functions in one:

=IFS(F3=1;G3*plano_vendas!\$H\$5;F3=2;G3*plano_vendas!\$I\$5;F3=3;G3*plano_vendas!\$J\$5)

=IFS(AND(F5=1;G5=0.5);1*plano_vendas!K5;AND(F5=2;G5=0.5);1*plano_vendas!L5;AND(F5=3;G5=0.5);1*plano_vendas!M5)

Is it possible?

3 Replies

# Re: Is it possible to combine two IFS functions in one?

Depends on which logic do you mean. IFS() checks conditions one by one and stops evaluation on first TRUE condition ignoring the rest.

# Re: Is it possible to combine two IFS functions in one?

Yes, that is what is happening when I try to combine the two functions. What I need is to have the conditions in the first function and at the same time, when the value of F5 is 1, 2 or 3 and G5 is 0.5, I want to use the value that corresponds to 1, 2 and 3, that is in the other sheet, to do the calculation.

# Re: Is it possible to combine two IFS functions in one?

Well end up trying this and it works:

=IFS(AND(F3=1;G3=0.5);1*plano_vendas!K5;AND(F3=2;G3=0.5);1*plano_vendas!L5;AND(F3=3;G3=0.5);1*plano_vendas!M5;F3=1;G3*plano_vendas!\$H\$5;F3=2;G3*plano_vendas!\$I\$5;F3=3;G3*plano_vendas!\$J\$5)

Thanks