I have this formula in a column: =IFERROR(IF(L4<0,1*(100/ABS(L4)),IF(L4>0,1*(ABS(L4)/100))),"")
But when there are no values in cells, it returns FALSE. How do I remove FALSE results?
Thanks in advance
I have this formula in a column: =IFERROR(IF(L4<0,1*(100/ABS(L4)),IF(L4>0,1*(ABS(L4)/100))),"")
But when there are no values in cells, it returns FALSE. How do I remove FALSE results?
Thanks in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks