function pfactor()
- From: Rita & Klaus Kuhnlein <rikla wynndel ca>
- To: Mailing list <gnumeric-list gnome org>
- Subject: function pfactor()
- Date: Sun, 1 Mar 2009 12:44:10 -0600
Hi,
I use gnumeric version 1.9.3 for Windows.
I try to calculate all primfactors of a given number:
A1: the given number
B1: =pfactor(A1)
A2: =A1/B1
B2: is copy of formula in cell B1
A3: is copy of formula in cell A2
and so on copied down to A20:B20
It works quite good and I get the prim factors listed in column B
except for one number: 12,345,678,901,234. There I get a #LIMIT! error
from B4 on.
=pfactor(12,079,920,647) creates the error.
The number 123,456,789,012,345, which is one digit longer than
12,345,678,901,234, works perfectly.
Is that a bug?
Regards
Klaus
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]