Hi all, Perhaps a straightforward question, however I cannot find a direct answer. I would like to have a BLANK formula for numbers, so IF ... THEN BLANK. Currently I have IF ... THEN 0 ELSE ... , however it has to be blank instead of zero. Is there a certain formula that works for numbers? Kind regards, Mickel
I don't think the link works?
HI,
It is possible to bring blank instead 0 in number format line item. Simple go to fromat and change the "Zero Format" to Blank. However if you try to put 0 in that line item it will be shown as Blank.
Hope this would be helpful!!.
Let me know if you have any concerns.
Thanks and Regards,
Kavin.