Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL: MOD FUNCTION or DIVISION
HELLO,
I'M TRYING TO DIVIDE NUMBERS IN MY EXCEL WORKSHEET. I HAVE A NUMBER IN CELL A1 [1000] AND IN CELL B1 IM TRYIN TO MAKE A FUNCTION TO [DIVIDE A1 BY THE NUMBER 35]. SO BASICALLY I WANT 1000 DIVIDED BY 35... I'VE TRIED " =MOD(A1,35) " BUT THE ANSWER IS WRONG I ALSO TRIED " =MOD(1000,35) " AND THAT ANSWER WAS ALSO WRONG HOW DO I GET A FUNCTION TO DIVIDE A CELL BY 35? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL: MOD FUNCTION or DIVISION
For division mod returns the remainder if any, in cell B1 put =A1/35
-John "NAIMA" wrote: HELLO, I'M TRYING TO DIVIDE NUMBERS IN MY EXCEL WORKSHEET. I HAVE A NUMBER IN CELL A1 [1000] AND IN CELL B1 IM TRYIN TO MAKE A FUNCTION TO [DIVIDE A1 BY THE NUMBER 35]. SO BASICALLY I WANT 1000 DIVIDED BY 35... I'VE TRIED " =MOD(A1,35) " BUT THE ANSWER IS WRONG I ALSO TRIED " =MOD(1000,35) " AND THAT ANSWER WAS ALSO WRONG HOW DO I GET A FUNCTION TO DIVIDE A CELL BY 35? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL: MOD FUNCTION or DIVISION
HOW DO I ROUND THE ANSWER DOWN?
"John Bundy" wrote: For division mod returns the remainder if any, in cell B1 put =A1/35 -John "NAIMA" wrote: HELLO, I'M TRYING TO DIVIDE NUMBERS IN MY EXCEL WORKSHEET. I HAVE A NUMBER IN CELL A1 [1000] AND IN CELL B1 IM TRYIN TO MAKE A FUNCTION TO [DIVIDE A1 BY THE NUMBER 35]. SO BASICALLY I WANT 1000 DIVIDED BY 35... I'VE TRIED " =MOD(A1,35) " BUT THE ANSWER IS WRONG I ALSO TRIED " =MOD(1000,35) " AND THAT ANSWER WAS ALSO WRONG HOW DO I GET A FUNCTION TO DIVIDE A CELL BY 35? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL: MOD FUNCTION or DIVISION
Put this in B1 and it rounds to the nearest whole number
=ROUND(A1/35,0) -John "NAIMA" wrote: HOW DO I ROUND THE ANSWER DOWN? "John Bundy" wrote: For division mod returns the remainder if any, in cell B1 put =A1/35 -John "NAIMA" wrote: HELLO, I'M TRYING TO DIVIDE NUMBERS IN MY EXCEL WORKSHEET. I HAVE A NUMBER IN CELL A1 [1000] AND IN CELL B1 IM TRYIN TO MAKE A FUNCTION TO [DIVIDE A1 BY THE NUMBER 35]. SO BASICALLY I WANT 1000 DIVIDED BY 35... I'VE TRIED " =MOD(A1,35) " BUT THE ANSWER IS WRONG I ALSO TRIED " =MOD(1000,35) " AND THAT ANSWER WAS ALSO WRONG HOW DO I GET A FUNCTION TO DIVIDE A CELL BY 35? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL: MOD FUNCTION or DIVISION
=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 :) :) "John Bundy" wrote: Put this in B1 and it rounds to the nearest whole number =ROUND(A1/35,0) -John "NAIMA" wrote: HOW DO I ROUND THE ANSWER DOWN? "John Bundy" wrote: For division mod returns the remainder if any, in cell B1 put =A1/35 -John "NAIMA" wrote: HELLO, I'M TRYING TO DIVIDE NUMBERS IN MY EXCEL WORKSHEET. I HAVE A NUMBER IN CELL A1 [1000] AND IN CELL B1 IM TRYIN TO MAKE A FUNCTION TO [DIVIDE A1 BY THE NUMBER 35]. SO BASICALLY I WANT 1000 DIVIDED BY 35... I'VE TRIED " =MOD(A1,35) " BUT THE ANSWER IS WRONG I ALSO TRIED " =MOD(1000,35) " AND THAT ANSWER WAS ALSO WRONG HOW DO I GET A FUNCTION TO DIVIDE A CELL BY 35? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL: MOD FUNCTION or DIVISION
Use INT()
|
#7
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) |