Help With Formula for Posting

[JoannieMaj]

I have no idea what to call this function!
I need to set up a worksheet to receive payments. 1st Column is th
total payment. I then need to take that amount and post $45 into th
first column, the next $380 into room and board, and the remainder (i
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" th
amounts into the next column and move the remainder to the next, etc. I
my defense I'm on prescription pain killers and a little punchy!
Please help! Thanks

 

[Mazzaropi]

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/juks8

I hope it helps
Have a nice day

 

[lhkittle]

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(E1>45,45,IF(E1<45,E1,"NSF"))
In G1 =IF(F1<45,"NSF",IF(E1>425,380,(E1-45)))
In H1 =IF(E1>425,(E1-425),"NSF")

Where NSF = Non Sufficient Funds

Regards,
Howard

 

[lhkittle]

Try this.



Amt paid in E1



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

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

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



Where NSF = Non Sufficient Funds



Regards,

Howard

Forgot to mention, then pull down.

H

 

[joeu2004]

In F1 =IF(E1>45,45,IF(E1<45,E1,"NSF"))
In G1 =IF(F1<45,"NSF",IF(E1>425,380,(E1-45)))
In H1 =IF(E1>425,(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. )

 

[JoannieMaj]

AMAZING! Absolutely amazing! Thank you so very much !