SOLVED

PROBLEMA CON FORMULA CONDICIONAL

Copper Contributor

 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

@ALEX_HAP 

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

 

=SI(J10>0;0;I10)

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

 

REGARDS

1 best response

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

@ALEX_HAP 

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

 

=SI(J10>0;0;I10)

View solution in original post