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
Deleted Would be helpful if you could show the formula that returns the zero.