Forum Discussion
IFS Function
Hi,
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 😀 )
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 😀 )