May 11 2021 10:18 AM
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.
May 11 2021 10:40 PM
@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.