Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas for changing formulas? | Excel Discussion (Misc queries) | |||
How do you create formulas in pivot table eg simple division? | Excel Worksheet Functions | |||
Formulas not working | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) |