Im working on a spreadsheet where I want Column E to be 1/5th of the dollar
value in Column D. So far Ive 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 Im doing wrong and how to correct this problem? Is there a way to
format the entire column to reflect 1/5 of the previous columns value so I
dont have to retype the formula in every column E cell?

A BIG thanks to anyone who can help!