IF(and([resta de abono]>=0,[resta de abono]<=[atraso antes del pago]),[resta de abono],if([resta de abono]>[atraso antes del pago],[atraso antes del pago],0
me marca error si alguien me puede orientar donde esta el error gracias
You have mismatched parentheses
Try
IF (and ([subscription subtraction]> = 0, [subscription subtraction] <= [delay before payment]), [subscription subtraction], IF([subscription subtraction]> [delay before payment], [delay before payment], 0))
According to the error message, the resta de abono column is not of a numeric type, and so cannot be compared to the number 0. To evaluate ([resta de abono] <= 0 )
, the resta de abono column must be a numeric type, such as Number or Decimal.
You also have an extraneous character in the expression:
I believe it should be the English word AND
.
Hola, me parece que estรกs duplicando las condiciones para que sea 0 (cero), prueba sin el = a cero en la condiciรณn AND ya que si hay un valor 0 la formula validarรญa dos condiciones (la primera y la รบltima) saludosโฆ
gracias!!
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |