Divide and place remainder in separate cell

[austenr]

I need to be able to read column A and divide that number by 3. If it is divisible by 3 then do nothing, if there is a remainder then place it in the first available space in column A on sheet 2. The goal is to determine how much over or under people pay each month. sample workbook attached. Thanks

[Killian]

Modulus divides a number by a divisor and returns the remainder

So in Cell A1 on Sheet to, add the formula:

=MOD(Sheet1!A1,3)

and drag down...

[austenr]

Thanks. That got it. Solved.