Forum Discussion
ALEX_HAP
Oct 06, 2023Copper Contributor
PROBLEMA CON FORMULA CONDICIONAL
Hola,tengo un problema con una formula condicional, formula hace su función, pero EXCEL me dice que hay un problema circular ,a parte...,en la fila donde esta aplicada la formula teniendo formato de numero y aplicando la formula de sumado no se realiza la operación quedando la operación siempre en 0.
La formula es : =SI(J10>0;K10=0;I10)
Hello, I have a problem with a conditional formula, the formula does its job, but EXCEL tells me that there is a circular problem, apart..., in the row where the formula is applied, having a number format and applying the addition formula, no operation is performed, leaving the operation always at 0.
The formula is: =IF(J10>0;K10=0;I10)
gracias
un saludo
2 Replies
- ALEX_HAPCopper Contributor