The MOD function returns the modulus or remainder after a division
operation. In this case =MOD(25,5) would correctly evaluate to zero.

If I understand correctly what you are trying to do, the formula you are
looking for is simply =Dx/5.

You can enter the formula in one cell and then select the cell where you
have entered the formula. In the lower right corner of the cell there is a
small square, this is the fill handle. Click and drag the fill handle down
the column as far as you wish.

--
Carlos

"MiniReefKeeper" wrote in message
...
I'm working on a spreadsheet where I want Column E to be 1/5th of the
dollar
value in Column D. So far I've had to enter =MOD(Dx,5) for each D cell
(ie
"x") value. This works for some of the values, yet others auto-calculate
wrong. I.e. when I typed in $15.31 in cell D17, it showed $0.31 in E17;
and
$25.00 auto-calculated as $-. Yet it seems to work correctly for 12.41
and
12.50 values. The cells have been formatted to "currency". Can anybody
tell
me what I'm doing wrong and how to correct this problem? Is there a way
to
format the entire column to reflect 1/5 of the previous' column's value so
I
don't have to retype the formula in every column E cell?

A BIG thanks to anyone who can help!