| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding up?
Hello, I have a sheet that splits a number up over several collums by a percentage then adds data from other collums. The percentage splits, which are decimals all add up to 100 when summed, however, the total of the number when split is short a few decimal places. I think this may have something to do with rounding up. Can anyone make anysence of this?? =IF((($AF41*FL$4)-($AF41*FL$4))0.2499,CEILING(($AF41*FL$4),0.5),IF( ($AF41*FL$4)0,($AF41*FL$4),0)) Thanks, Sam -- scriblesvurt ------------------------------------------------------------------------ scriblesvurt's Profile: http://www.excelforum.com/member.php...o&userid=24399 View this thread: http://www.excelforum.com/showthread...hreadid=478169 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| Rounding up @ 3 instead of 5 | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Rounding | Excel Worksheet Functions | |||
| Worksheet rounding vs VBA rounding | Excel Programming | |||
![scriblesvurt[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
