Oct 06 2023 01:46 AM
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
Oct 06 2023 02:58 AM
SolutionOct 06 2023 03:16 AM