| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested formulas in excel
Thank you very much!
"Sameer Nagi" wrote: 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 "sleeplessinseattle" wrote: 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested-IF formulas | Excel Discussion (Misc queries) | |||
| help in nested if formulas | Excel Worksheet Functions | |||
| if nested formulas | Excel Discussion (Misc queries) | |||
| nested formulas | Excel Discussion (Misc queries) | |||
| nested formulas | Excel Worksheet Functions | |||
Threaded Mode
