How to convert dash value into zero value

Pooja_D — Wed, 27 Sep 2023 08:14:56 GMT

Hello All,

I want to replace null, '-' Value with 0 (Numeric Zero) by Script level or sheet level.

I tried below syntax,

If (isnull(YourExpression),0,YourExpression)

but it's not working.

Kindly suggest.

Thanks,

Pooja

Re: How to convert dash value into zero value

agigliotti — Wed, 27 Sep 2023 08:17:48 GMT

You can use:

Alt( YourExpression, 0 )

I hope it can help.

Best Regards