nested formulas in excel

[Guest]

Have a worksheet where I am tracking payments which may be made in full or
may be made in two installments. I have written a very simple formula which
subtracts the values in two columns (installments) from the total due column,
however, when individuals pay in two installments, they are chaged an
additional $50 fee. For instance, the total due for the class they are
taking is $1350 which they may pay in full which results in a balance due of
0; but if they pay a $400 deposit, they actually owe $1000 but my formula
returns the correct value of $950 (mathematically correct). Is there some
way to use a nested formula to return the value of $1000 when that condition
applies?

 

[Guest]

Hi Sleepless,

Suppose you make 3 columns:

Total Fees (Cell B5) Paid 1st Installment (Cell C5)
Due Now (D5)

Then in D5 you can use this formula:

=IF(C5=B5,0,IF(C5<B5,(B5-C5)+50,""))


ENJOY!!!!!!

Regards,
Sameer Nagi

 

[Guest]

you could express this w/o the nested IF's:
=B5-C5+((C5<B5)*50)

 

[Guest]

Thank you very much!

Hi Sleepless,

Suppose you make 3 columns:

Total Fees (Cell B5) Paid 1st Installment (Cell C5)
Due Now (D5)

Then in D5 you can use this formula:

=IF(C5=B5,0,IF(C5<B5,(B5-C5)+50,""))


ENJOY!!!!!!

Regards,
Sameer Nagi