| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
ROUNDUP
Will ROUNDUP work if I want to take the sum of so many rows and round it to
the next whole # even if it should be rounded down. i.e. the # is 5.33, but I want it to show 6. |
|
#2
|
|||
|
|||
|
frustratedwthis wrote: Will ROUNDUP work if I want to take the sum of so many rows and round it to the next whole # even if it should be rounded down. i.e. the # is 5.33, but I want it to show 6. Yes assuming 5.33 is in cell A1 use the formula =ROUNDUP(A1,0) Using "0" rounds to the nearest integer. -- Message posted via http://www.officekb.com |
|
#3
|
|||
|
|||
|
Did you try? Apparently not...
Yes, it will work. Roundup(5.33,0)=6 "frustratedwthis" wrote: Will ROUNDUP work if I want to take the sum of so many rows and round it to the next whole # even if it should be rounded down. i.e. the # is 5.33, but I want it to show 6. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDUP IN 0.2 INCREMENTS | Excel Worksheet Functions | |||
| Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
| How do I apply the ROUNDUP formula to a range of calculated data | Excel Worksheet Functions | |||
| roundup seconds to minute | Excel Worksheet Functions | |||
| Roundup | Excel Worksheet Functions | |||
Linear Mode
