| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
stop rounding up in a colum that contains decimals in excel
the answers in 6 cells need to be *0.387 these round up or down (this is ok)
but when i need to add these up 6 cells up its still taking the 3rd decimal place in to account eg 15*0.387= £5.81, 10*0.387=£3.87. 30*0.387=£11.61 these 3 are duplicated once more, when i add them up the answer is coming out as £42.57 and shoud be £42.58 plase can you help me |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Marcro recroding/ stop Ikon not appearing in middle of excel sheet | Excel Discussion (Misc queries) | |||
| Stop excel emedding (opeing in mail format) when outlook is open. | New Users to Excel | |||
| Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
| Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
Threaded Mode
