We need to pay commission at a certain %age to the selling agents. The Commission is paid on a cumulative basis requiring adjustment due to rounding off. But the rounding off results in a difference of $1 (Less or Excess) on entry wise basis. What I need is a Formula to adjust the INCOME itself so as to set the difference to Zero without changing the overall Income. The Commission amount is to remain intact. All the Negative differences must be adjusted, but +ve difference may remain. Any Negative Income is to be adjusted in next entry to the extent possible.