Originally Posted by JoannieMaj

I have no idea what to call this function!
I need to set up a worksheet to receive payments. 1st Column is the total payment. I then need to take that amount and post $45 into the first column, the next $380 into room and board, and the remainder (if any) in to tuition.

Amount Paid Application Fee Room & Board Tuition

$905.00 $45.00 $380.00 $480.00
$195.00 $45.00 $150.00 $0.00
$500.00 $45.00 $380.00 $75.00

For some reason I can't wrap my head around how to make them "feed" the amounts into the next column and move the remainder to the next, etc. In my defense I'm on prescription pain killers and a little punchy!
Please help! Thanks!