| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I get excel 2003 to round up
i have the following formula but i need the results to round up if there are
3 digits after the decimal point =IF(B3<=0," ",IF(B30,(D2+B3)*1.5%)) excample 8.011 would become 8.02 what do i need to add to this formula to make it do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
| can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
| Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) | |||
Threaded Mode
