| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i round up the sum of a formula
I woul like to round up the sum of a formula
=K11+(M7*25%) =115+(22*25%)=120.5 shouldshow 121 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i round up the sum of a formula
The "0" determines the number of decimal places. =ROUNDUP(115+(22*25%),0) -- bgeier ------------------------------------------------------------------------ bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822 View this thread: http://www.excelforum.com/showthread...hreadid=546234 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i round up the sum of a formula
Hi Ian,
Try: =ROUND(115+(22*25%),0) See also the ROUNDUP and ROUNDDOWN functions in Excel help. --- Regards, Norman "ian" wrote in message ... I woul like to round up the sum of a formula =K11+(M7*25%) =115+(22*25%)=120.5 shouldshow 121 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| formula to round up to nearest 1,000 | Excel Discussion (Misc queries) | |||
| Round amount to nearest $10 after other formula calc. in same cell | Excel Worksheet Functions | |||
| Formula to enter to round an Excel value up to the next $0.5? | Excel Discussion (Misc queries) | |||
| If the SUM of a list is 32.2 what formula to round it up to 32.5? | Excel Worksheet Functions | |||
Linear Mode
