PDA

View Full Version : [SOLVED] Divide and place remainder in separate cell



austenr
09-20-2005, 06:40 AM
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
09-20-2005, 06:54 AM
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
09-20-2005, 07:39 AM
Thanks. That got it. Solved.