Hola a todos
Tengo la siguiente estructura condicional:
=if((Cod_Act='2531' and Cod_Art='1022878'),sum(Cant_R),
if((Cod_Act='2531' and Cod_Art='1022892'),sum(Cant_R),
if((Cod_Act='2531' and Cod_Art='1022894'),sum(Cant_R),
if((Cod_Act='2531' and Cod_Art='1022867'),sum(Cant_R),
if((Cod_Act='2531' and Cod_Art='1022874'),sum(Cant_R),
if((Cod_Act='2531' and Cod_Art='1028788'),sum(Cant_R),
if((Cod_Act='2551' and Cod_Art='1022878'),sum(Cant_R),
if((Cod_Act='2551' and Cod_Art='1022892'),sum(Cant_R),
if((Cod_Act='2551' and Cod_Art='1022894'),sum(Cant_R),
if((Cod_Act='2551' and Cod_Art='1022867'),sum(Cant_R),
if((Cod_Act='2551' and Cod_Art='1022874'),sum(Cant_R),
if((Cod_Act='2551' and Cod_Art='1028788'),sum(Cant_R),
0))))))))))))
Quisiera me indiquen si es posible simplificarla
Gracias
