View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
m1121 m1121 is offline
external usenet poster
 
Posts: 1
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). 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?