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!

JoannieMaj, Good evening.

I did a suggestion of solution for you.

Take a look at it and tell us if it worked for you.
http://www.sendspace.com/file/juks85

I hope it helps.
Have a nice day.

On Saturday, June 22, 2013 12:33:42 PM UTC-7, JoannieMaj wrote:
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!

JoannieMaj

Try this.

Amt paid in E1

In F1 =IF(E145,45,IF(E1<45,E1,"NSF"))
In G1 =IF(F1<45,"NSF",IF(E1425,380,(E1-45)))
In H1 =IF(E1425,(E1-425),"NSF")

Where NSF = Non Sufficient Funds

Regards,
Howard

On Saturday, June 22, 2013 2:46:56 PM UTC-7, wrote:
On Saturday, June 22, 2013 12:33:42 PM UTC-7, JoannieMaj wrote:

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!



JoannieMaj



Try this.



Amt paid in E1



In F1 =IF(E145,45,IF(E1<45,E1,"NSF"))

In G1 =IF(F1<45,"NSF",IF(E1425,380,(E1-45)))

In H1 =IF(E1425,(E1-425),"NSF")



Where NSF = Non Sufficient Funds



Regards,

Howard

Forgot to mention, then pull down.

H

wrote:
In F1 =IF(E145,45,IF(E1<45,E1,"NSF"))
In G1 =IF(F1<45,"NSF",IF(E1425,380,(E1-45)))
In H1 =IF(E1425,(E1-425),"NSF")
Where NSF = Non Sufficient Funds

And all this time I thought my bank was notifying me of a gift from the
National Science Foundation. :-))

AMAZING! Absolutely amazing! Thank you so very much !