0

dividing a blank text cell returns "35791394.11666667"

I can work around this by filtering out blanks, but it's a puzzler

I've got a calc which uses split part to take the first column and return minutes, seconds, and seconds as a decimal representation

So for the first and third row it works swell.   The middle row contains a blank ( filtering for non-null does not eliminate the row ), returns a blank ( empty set? null? ) for both minutes and seconds, but returns 35791394.11666667 for seconds / 60 

 

"3:26","3","26",".4333333333333333"
"","","","35791394.11666667"
"3:40","3","40",".6666666666666666"

 

As mentioned, in my current use case I can get around it by filtering blanks or - more likely - but testing the condition in a CASE statement, but I'm curious to know the cause so it doesn't bite me in future formulae.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 mths agoLast active
  • 1Replies
  • 17Views
  • 2 Following

Product Announcement

Incorta 5 is now Generally Available