| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Student loan formula
Divide by 12
-- HTH Bob "Scoober" wrote in message ... Hi Tom, Sorry your formula has worked (i Has something written in e32) Can you tell me how to make this answer in a monthly amount as it is showing in a yearly figure (something i did not think about in my original question) -- Thanks in advance. Scoober "Tom-S" wrote: Try this: =IF(OR(H31<18142,H33<18142,AND(E31="no",E33="no")) ,"",(SUMPRODUCT((E31:E33="yes")*(H31:H33))-COUNTIF(E31:E33,"=yes")*18148)*0.1) Please note, this assumes that cells E32 and H32 are both empty. "Scoober" wrote: Hi all, I am trying to get this formula to complete a student loan formula. =IF(AND(H31=H33,H31="no"),"",IF(AND(H31=H33,H31="y es"),(H31-18148)*0.1+(E33-18148)*0.1) h31 = income h33 =income e31 = yes/no e33 = yes/no So if yes is selected in e31 and or e33 i need the formula (h31-$18,148)*10%. There is also a need to show no result if either applicants income is less than $18,142. Of course only one applicant may have a student loan and the other may not. So i need the formula to populate the object cell with nothing if neither applicants have a student loan, the answer if 1 applicant has a student loan but the other does not or add the answer together if both have a student loan. Can you see where i have gone wrong in my attempt? -- Thanks in advance. Scoober |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Student loan payment schedule? | Excel Discussion (Misc queries) | |||
| Student Loan Consolidation | Excel Discussion (Misc queries) | |||
| Federal and Private Student Loan Consolidation Programs | Excel Worksheet Functions | |||
| Medical Student Loan Consolidation | Excel Discussion (Misc queries) | |||
| Medical Student Loan Consolidation | Excel Worksheet Functions | |||
![Bob Phillips[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
