Impossible to use number 98 in DC CONCATENATE function

Hi everyone!
I’m doing a course for an italian enterprise, and we tried to use the CONCATENATE function in the ItemCode. But there is a very strange behaviour: if we use the number 98 (for the height of the table) it doesn’t appera in the ItemCode string. If we use an other number everything works well! But with the number 98 does not!!! I’m going crazy… can someone help me please? The DC in attachement… Thank you!

TAVOLO DINAMICO_6.skp (18.5 KB)

(1) Your last IF function only has 2 arguments. The condition and the true value.
Why is there no false value ?

Your formulae do not need the last IF function.

Same situation in the CODICE_ARTICOLO formula.

Ie …

=CONCATENATE("EA",
  IF(LUNGHEZZA="140","14",
    IF(LUNGHEZZA="160","16","20")
  ),
  IF(LARGHEZZA="60","06",
    IF(LARGHEZZA="80","08","10")
  ),
  "M",
  IF(ALTEZZA="45","45",
    IF(ALTEZZA="74","74","98")
  )
)
1 Like

Gasp! You are right…!!!
Probably we were very tired that day. Now it’s obvious our error! Thank you so mutch!

2 Likes