Forum Discussion
IFS Function
Hi,
I am using IFS Function in C13. Now, the problem the formula returns 0 as you can see in the table if the "Collected By" column is empty. How can I make the function to return nothing if the "Collected By" is empty?
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
7 Replies
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 😀 )
Deleted Would be helpful if you could show the formula that returns the zero.
