View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Bundy John Bundy is offline
external usenet poster
 
Posts: 125
Default 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?