Post Reply 
a b/c unexpected function
09-04-2020, 07:48 AM (This post was last modified: 09-04-2020 07:52 AM by ijabbott.)
Post: #9
RE: a b/c unexpected function
(09-03-2020 08:13 PM)celltx Wrote:  Wow! I see there is a lot of thought behind that simple button press. Actually, it all started from the point that I wanted to find a simple way to figure out the number of leading zeroes in small number s. Like, if I have 0.000002, I'd like to count the number of leading zeroes in a quick way. But not resorting to the global scientific notation for that.

Initially, I thought the [a b/c] button could be somewhat helpful, but it seems to have a completely different function.

Thank you for the explanation, Joe!

You could use the LOG function for the number of leading zeros:
-IP(LOG(0.000002)) = 5

It doesn't work for numbers such as 0.1, 0.01, 0.001, but those would have a fractional part after the LOG() function that could be tested for.

— Ian Abbott
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
a b/c unexpected function - celltx - 09-03-2020, 05:10 PM
RE: a b/c unexpected function - Joe Horn - 09-03-2020, 06:21 PM
RE: a b/c unexpected function - Joe Horn - 09-04-2020, 12:41 AM
RE: a b/c unexpected function - celltx - 09-03-2020, 07:01 PM
RE: a b/c unexpected function - Joe Horn - 09-03-2020, 07:29 PM
RE: a b/c unexpected function - celltx - 09-03-2020, 08:13 PM
RE: a b/c unexpected function - ijabbott - 09-04-2020 07:48 AM
RE: a b/c unexpected function - celltx - 09-04-2020, 04:23 PM
RE: a b/c unexpected function - Joe Horn - 09-04-2020, 05:24 PM



User(s) browsing this thread: 1 Guest(s)