SOLVED

# PROBLEMA CON FORMULA CONDICIONAL

Copper 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
best response confirmed by ALEX_HAP (Copper Contributor)
Solution

# Re: PROBLEMA CON FORMULA CONDICIONAL

Is this formula in K10? If so, change it to

=SI(J10>0;0;I10)

# Re: PROBLEMA CON FORMULA CONDICIONAL

@HansVogelaar  GREAT!!! IT WORKS!!! THANKS A LOT!!

REGARDS

1 best response

Accepted Solutions
best response confirmed by ALEX_HAP (Copper Contributor)
Solution

# Re: PROBLEMA CON FORMULA CONDICIONAL

Is this formula in K10? If so, change it to

=SI(J10>0;0;I10)