Feb 07 2021 07:06 PM
Feb 07 2021 10:22 PM
@Deleted Would be helpful if you could show the formula that returns the zero.
Feb 08 2021 12:38 AM
Solution@Deleted
If it's returning text, then you could wrap your entire formula in T( ) that will return a blank instead of a zero.
Alternatively you could just format your cell to show blanks for zeros (although I'd recommend putting a small dash or something just to show there's nothing there
or
Wyn
MVP
UTC+8
Feb 10 2021 11:27 PM - edited Feb 10 2021 11:34 PM
Hi, Thank you so much Wyn for your help!
Now, the problem I am facing is that I do not have 'Empty list' in Custom
Feb 11 2021 05:43 PM
Feb 11 2021 07:29 PM
I noticed that, too! Perhaps, marking one's own reply as "best response" must be disabled. In the academe, such is analogous to checking your own paper and determining your own rating, based on your own standards.
Feb 11 2021 08:45 PM
I am so sorry for that guys, I meant to mark yours. Please accept my apology, it was a genuine mistake and I will correct it.
Feb 08 2021 12:38 AM
Solution@Deleted
If it's returning text, then you could wrap your entire formula in T( ) that will return a blank instead of a zero.
Alternatively you could just format your cell to show blanks for zeros (although I'd recommend putting a small dash or something just to show there's nothing there
or
Wyn
MVP
UTC+8