View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default My division formulas do not have the correct remainder, why?

I am trying to divide the value in a cell by 1.085. My formula looks like
this:=MOD(B8,1.085).


What is the value of B8 and what result are you getting and what result do
you expect?

Biff

"m1121" wrote in message
...
I am trying to divide the value in a cell by 1.085. My formula looks like
this:=MOD(B8,1.085). I've used the formula wizard. The result is
incorrect.

In another area on the worksheet, I want to divide one cell value by
another
cell value. My formula looks like this: =MOD(B8/E8). The result is
incorrect.

Any ideas what I'm doing wrong?