Formula integer

[kboschJGDNZ]

Hello

I want the following formula to work with integers:

IF(condition=true,show parameter, show nothing)

This however only works when I fill a number at the last part. (show nothing = 0 or some other number)

"Show nothing" with a text parameter is just "", but with integers this doesn't work

Does anyone know a way to make this work?

[L.Maas · Accepted solution]

While for a string "" is still a string. For integers you will need an integer value. So unfortunately you can not make this work. There have been ideas to be able to reset a parameter back to null (not assigned), but this is not implemented (yet?).

[kboschJGDNZ]

Ok that's a pitty then. Hopefully this will be implemented some day.

[ToanDN]

You would wish there is something like what you can do in Excel, would you not?  Alas...

[kboschJGDNZ]

Now I think about it...you can suppress trailings...I wonder if you can supress a single zero. I'll check this out when I'm at work.