How do I get a cell to round up by $1.00 without changing the sum total? I
know how to make it round up by one or two places. Example: Cell (A1=
$1,333)+(A2=$1,333)+(A3=1,333). Cell A4 is a sumtotal which equals $4000.
When I sum these cells, the total is 4000. However, If you manually add
these amounts you will see that the correct total really is 3999. I need to
make cell A1 equal $1334 without manually adding 1 at the end of the formula,
which ultimately affects the sum total cell. Does anybody have any
suggestions?