LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formulas for changing formulas? creativeops Excel Discussion (Misc queries) 4 January 26th 06 03:07 AM
How do you create formulas in pivot table eg simple division? Belinda_Tim Excel Worksheet Functions 2 January 5th 06 03:03 PM
Formulas not working John Lovin Excel Discussion (Misc queries) 3 January 18th 05 10:50 PM
How to make Excel run limited number of formulas on a given worksh John Excel Discussion (Misc queries) 0 January 12th 05 04:29 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 04:23 PM


All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"