Forum Discussion

ALEX_HAP's avatar
ALEX_HAP
Copper Contributor
Oct 06, 2023
Solved

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

Resources