Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If the SUM of a list is 32.2 what formula to round it up to 32.5?
If I add a list of numbers using the formula =SUM( ) and the total is 32.25 -
what formula must I use to get the result that the total will be 32.50. If the total is 40.70 the result must round up to 41.0. The problem arises when I add metres of fabric and need to round the total to the next half metre. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) |