"Si anidada "

Copper Contributor

Hola estimados

 

Me pueden ayudar a anidar la función si en una misma celda, en el archivo adjunto de nómina tengo cinco fórmulas con si (h2,h3, h4, h5, h6) y las quiero anidar en una misma celda.

 

adjunto el archivo.

 

 

 

 

1 Reply

@dbravog Please have a look at the attached file. You asked for an "all-in-1" formula. Nor very straight forward, but with doable with some named ranges and the SUMPRODUCT function.

 

Have changed the set-up of your "Look-up table" and included some helper columns that hopefully clarify the process. The "all-in-1" solution is in cell H11 and down.