Función demasiado larga

21/01/2009 - 21:00 por bavaro | Informe spam
Estiamdos:
Tengo un reporte que quiero traspasar las fórmulas a Excel y tengo el
siguiente problema, tengo una fórmula que excede la capacidad en el
excel, como puedo optimizar esta fórmula, ejemplo :

if stock_0>(entradas_120+mes-0+mes-30+mes-60+mes90) then
(entradas_120) else (Stock_0-(mes-0+mes-30+mes-60+mes90)

Serí aalgo así :
=SI($T11>($J11+
SI($R11>$T11,$T11,$R11) +
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11)))) +
SI($T11>($N11+SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11))))),
$N11,($T11-((SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11)))))))) +
SI($T11>($L11+
SI($R11>$T11,$T11,$R11) +
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11)))) +
SI($T11>($N11+SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11))))),
$N11,($T11-((SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11))))))))
),$L11,($T11-
(SI($R11>$T11,$T11,$R11) +
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11)))) +
SI($T11>($N11+SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11))))),
$N11,($T11-((SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11))))))))
)))
), $J11,
($T11-(
SI($R11>$T11,$T11,$R11) +
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11)))) +
SI($T11>($N11+SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11))))),
$N11,($T11-((SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11)))))))) +
SI($T11>($L11+
SI($R11>$T11,$T11,$R11) +
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11)))) +
SI($T11>($N11+SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11))))),
$N11,($T11-((SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11))))))))
),$L11,($T11-
(SI($R11>$T11,$T11,$R11) +
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11)))) +
SI($T11>($N11+SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11))))),
$N11,($T11-((SI($R11>$T11,$T11,$R11)+
SI($T11>($P11+SI($R11>$T11,$T11,$R11)),$P11,($T11-(SI($R11>
$T11,$T11,$R11))))))))
)))
))
 

Leer las respuestas

#1 juanjose_mm
21/01/2009 - 21:51 | Informe spam
Sería bueno que pusieses un ejemplo con datos (aunque sean ficticios)
de lo que tiene y lo que necesitas.
La función que pones es sumamente dificil de entender (por lo menos en
mi caso), por lo que lo ideal es empezar por el principio. Pon un
ejemplo lo más ajustado a la realidad y por ahí podemos empezar.

Saludos.

Preguntas similares