Hi MiniReefKeeper,

You are using the wrong formula.

MOD(15.31,5) = 0.31 is correct for that formula. The MOD formula gives
the REMAINDER after 15.31 is divided by 5. 15.31/5 = 3 remainder 0.31

To get one fifth of each column D value into the corresponding column E
cell..

1. Type this into E2....

=D2/5

2. Now, when you move the cursor (fat cross) so that it is positioned
directly over cell E2's bottom right-hand corner you should see it turn
into a skinny cross. When you see the cursor change double-click and
you should see the formula automatically fill column E with the correct
formula down to the row with the last column D value.

Ken Johnson