Forum Discussion
IFS Function
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
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
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
- Hi
Not sure what you mean sorry. You can type in your own 0.00;(0.00);"Empty List" into the Type box
(side note, you seem to have marked your own reply as best solution 😀 )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.
