I hope I'm posting in the correct forum as I am not a mathematician and believe perhaps
this is where I should post this question:
This may not be possible but I'm looking for a mathematical formula
such that the sum of any set of numbers in any combination will always
produce a result in which the decimals are less than .25
The initial values of the numbers that are being summed are set, BUT
the formula can modify them to produce the necessary result.
Take for example a series of values in distances:
1.25 miles
14.80 miles
7.72 miles
the sum is now 23.77
I would like a formula that when applied against the numbers for miles,
modifies those numbers such that any combination of them will result in
a number whose decimal portion is always less than or equal to .25
So 1.25, 14.80 and 7.72 needs to be adjusted with the formula so that
when you add any combination, i.e., 1.25 + 7.72 the sum will have a
decimal part that is less than or equal to .25
FYI: the formula WILL adjust the mile number, again in the above
example (1.25 and 7.72) so that their sum will have a decimal part
that is less than or equal to .25, like 1.25 stays the same but 7.72
would change to 7.80 so that the decimal part now has a value of 9.05
Is this possible?
Thanks


LinkBack URL
About LinkBacks