| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL: MOD FUNCTION or DIVISION
Pl turn off the caps lock ..
Some options to try: =ROUNDDOWN(A1/35,0) =INT(A1/35) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NAIMA" wrote: =ROUND(A1/35,0) HOW DO I GET IT TO ROUND DOWN TO THE WHOLE NUMBER 1000/35 = 28.571 I WOULD LIKE IT TO READ 28 INSTEAD OF 29 IS THAT POSSIBLE? THANK YOU FOR YOUR HELP :) :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
| How do i execute a VBA function by clicking on an excel cell? | Excel Discussion (Misc queries) | |||
| Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
