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?

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?

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?

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?

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?

EXCEL: MOD FUNCTION or DIVISION
 

Use INT()

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 :) :)