Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help needed summing fractional values which have been rounded up
I have formatted the cells so they don't show decimal places, which has the desired effect of rounding fractional numbers upwards i.e Original Rounded number number 9.0 9 3.0 3 3.5 4 2.5 3 1.0 1 0.5 1 The problem is when I try to get excel to sum a total for me. It seems to still be working on the fractional values rather than the whole numbers, so for the numbers above, it's totalling 19.5 rather than 21. Is there any way to fix this? -- madbloke ------------------------------------------------------------------------ madbloke's Profile: http://www.excelforum.com/member.php...o&userid=14422 View this thread: http://www.excelforum.com/showthread...hreadid=390519 |
#2
|
|||
|
|||
Use the ROUND formula: =ROUND(9.4,0) --9 =ROUND(9.5,0) --10 0 stands for 0 decimals Then sum the values Hope it helped Ola Sandström =ROUNDUP(9.1,0) -- 10 =ROUNDDOWN(9.1,0) -- 9 -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=390519 |
#3
|
|||
|
|||
That's cracked it! Cheers! -- madbloke ------------------------------------------------------------------------ madbloke's Profile: http://www.excelforum.com/member.php...o&userid=14422 View this thread: http://www.excelforum.com/showthread...hreadid=390519 |
#4
|
|||
|
|||
Happy it worked Thanks for the feedback Ola -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=390519 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing values | Excel Discussion (Misc queries) | |||
What is the best method for summing values where you want 2 value. | Excel Discussion (Misc queries) | |||
searching for values and summing the corresponding values | Excel Worksheet Functions | |||
Summing Values from different workbooks | Excel Discussion (Misc queries) | |||
Summing values of corresponding columns | Excel Worksheet Functions |