If Statement help

[Guest]

I have a run of cells that have values with 8 decimal places. This run of
numbers must end up totaling 1.00000000. I need an "if" that would look at
the sum and IF the total does not enter 1.00000000, if will go up and modilfy
the values so that they do equal 1.00000000.

 

[par_60056]

I have a run of cells that have values with 8 decimal places. This run of
numbers must end up totaling 1.00000000. I need an "if" that would look at
the sum and IF the total does not enter 1.00000000, if will go up and modilfy
the values so that they do equal 1.00000000.

Can us describe how the numbers are to be modified? Presumably you
would not just want 1 of the numbers lowered or raised at random to
make it equal. If I have .6, .4 and .1 totalling 1.1 it makes a lot
of difference where that .1 is removed from to make a total of 1.0.

One solution is to put a sum formula in formatted to display all
places and then you can adjust the numbers until the total is
1.000000000

Peter Richardson

 

[Guest]

Thanks Peter. We are currently using a sum formula and modifying from there.
The problem is that we are spend hours jockeying with the numbers because we
have a lot of files we work with. OUr thinking was that if a formula could
look above and round up or down to give us the 1.00000000, that would be
wonderful.

We have to then present a statement showing the run of numbers and the total
that equals 1.00000000. Each number in the run must be 8 decimals. Once the
client gets this statement - should they decide to run the number they see -
the total must be 1.00000000. Does that make sense?