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
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.
This is an interesting one. If you multiply 35791394.11666667 by 60, you get 2,147,483,647. That just happens to be the maximum value for a signed 32-bit integer. So my guess without seeing your formula is that the max integer value is being substituted in when the field is blank.