I have an array in which a number is multiplied by a percentage and then
those numbers are eventually totalled up. Example: 250*50% = 125,
250*25%=62.5, 250*25%=62.5, 125+62.5+62.5=250.

The question I have is: is there any way to have only integers displayed
throughout this process and still keep the correct total? When I try using
the round function now my total is off by 1. Any suggestions?

Hi,

Select the column (or row) containing the numbers (e.g., 125, 62.5, and
62.5) -- Rightclick on the selection -- "Format Cells" -- click on
"Numbers" Tab, "Category" to "Number" and "Decimal places" to 0. For the
cell containing the total, you can either format it also as above OR use the
ROUND function.

Regards,
B. R. Ramachandran

"Pete" wrote:

I have an array in which a number is multiplied by a percentage and then
those numbers are eventually totalled up. Example: 250*50% = 125,
250*25%=62.5, 250*25%=62.5, 125+62.5+62.5=250.

The question I have is: is there any way to have only integers displayed
throughout this process and still keep the correct total? When I try using
the round function now my total is off by 1. Any suggestions?