Need formula help if possible
 

I have a number such as 644.02. I need to develop a formula that will give
the result of all possible numbers that divide into it that have a sum that
results in an even number. This is a dollar amount that equates into postage
applied to envelopes or flats. I need to find out the possiblilities of what
rate was used on all pieces of mail, it will come to an even piece count once
I find that rate. Example:
$240 would come out to 400 pieces of mail at a rate of .60. With only one
known variable is there a way?

Here is a hammer and tong approach. Put your total postage amount
(644.02) in A1, =ROW() in B1, =A$1/B1 in C1, and
=IF(ROUND(C1,2)*B1=A$1,"OK","") in D1. Copy B1:D1 and paste down
through row 64402 (100*A1). Those combinations with "OK" in column D
are feasible.

More directly, what you want are the prime factors of 64402 (100*A1).
Any multiplicative combination of the prime factors (1, 2, 13, and 2447)
are possible piece counts.

Jerry

danlinksman wrote:

I have a number such as 644.02. I need to develop a formula that will give
the result of all possible numbers that divide into it that have a sum that
results in an even number. This is a dollar amount that equates into postage
applied to envelopes or flats. I need to find out the possiblilities of what
rate was used on all pieces of mail, it will come to an even piece count once
I find that rate. Example:
$240 would come out to 400 pieces of mail at a rate of .60. With only one
known variable is there a way?