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. 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 |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
a b/c unexpected function - celltx - 09-03-2020, 05:10 PM
RE: a b/c unexpected function - StephenG1CMZ - 09-03-2020, 05:44 PM
RE: a b/c unexpected function - Joe Horn - 09-03-2020, 06:21 PM
RE: a b/c unexpected function - Albert Chan - 09-03-2020, 08:30 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 - Albert Chan - 09-04-2020, 03:04 PM
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)