[Solved] nested IF, AND, OR function compare and give result excel

by


Try this formula

=MATCH(G5,{"Prica Plus","Miks S","Miks M","Miks L","Miks XL","Miks XL Plus","Miks XXL","Super"},0)-MATCH(F5,{"Prica Plus","Miks S","Miks M","Miks L","Miks XL","Miks XL Plus","Miks XXL","Super"},0)

Above formula can be broken down in two parts. Firstly, matching Cell G5 to your values

=MATCH(G5,{"Prica Plus","Miks S","Miks M","Miks L","Miks XL","Miks XL Plus","Miks XXL","Super"},0)

Secondly, matching Cell H5 to your values

=MATCH(F5,{"Prica Plus","Miks S","Miks M","Miks L","Miks XL","Miks XL Plus","Miks XXL","Super"},0)

then subtracting both values.

0

solved nested IF, AND, OR function compare and give result excel