Dividing. how do i ?

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

I am trying to multiply on a spreadsheet =MOD(45/12) and
the answer is coming back as 9. What did I do wrong? I
really need =MOD(Q5,12) for a formula, and i cannot get
it to divide. am I missing something? This is so
embarrasing
 
The formula worked for me with out the space between the D
and the (. You might want to try the wizard...
 
I am trying to multiply on a spreadsheet =MOD(45/12) and
the answer is coming back as 9. What did I do wrong? I
really need =MOD(Q5,12) for a formula, and i cannot get
it to divide. am I missing something? This is so
embarrasing
Click to expand...

Excel won't accept =MOD(45/12) as a valid formula because the MOD function
REQUIRES two arguments. If you meant to type =MOD(45,12), then the result is the
REMAINDER from dividing 45 by 12 - the quotient is 3 (3*12 = 36 < 45 while 4*12
= 48 > 45), and the remainder is 9.

If you want 45 divided by 12, i.e., 3.75, then enter =45/12 and omit the MOD
call.
 
Back
Top