On Mon, 10 Oct 2005 13:54:51 -0500, AMarie
wrote:


I'm sorry for being unclear,

Perhaps "rounding" is the incorrect term for me to use. In any event,
in a list of the following numbers - .3989, .4603, and .1407 (which
equals .9999) needs to equal .1 (or 100 after I multiply it by 100).

3989 will be changed to .4 then multiplied by 100 to be 40, .4603 will
remain but the "03" will be truncated off, the same is true for .1407 -
the "07" will be truncated off. .46 and .14 will be multiplied by 100 so
my new numbers would be 40, 46, and 14 which would equal 100.

The excel formula will look at the three numbers, determine which ones
need to be changed for the total to equal 100.

Perhaps I'm analyzing it too deeply but it seems like there will have
to be an array and an if statement and perhaps some looping.


Did you try the solution I posted?

Just modify it by multiplying each formula by 100.


--ron