Is it possible to combine two IFS functions in one?

[aigr_pt]

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?

[#2]

@aigr_pt 

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

[#3]

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.

[#4]

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