Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding in an array
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Array with Array | Excel Worksheet Functions | |||
Excel array formulas | Excel Discussion (Misc queries) | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |