# Calculating Percentages

#### cbwidow1

##### New Member

This message was edited by cbwidow1 on 2002-10-29 19:41
This message was edited by cbwidow1 on 2002-10-29 19:49

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Given the infomation supplied, I set up a simple schedule. It this what you had in mind...if not, please give a few more details
test7.xls
FGHIJKLMNO
26
27PrincipalPrincipal11%
28periodBal begPaymentBal endInterestTotal
2912800026227738256.67518.67
3022773826227476254.27516.27
3132747626227214251.86513.86
32
33
Sheet1

pll

OK i got that part but can you show me what I have to do to get the balance to show how much is really being paid? I dont want to see how much my interest and my house payment together is. I want to see how much is being paid toward the princible when the interest is being add on.I know it is like \$28.28 I`ll do the rest of the caculations later in my program.ty for your help ,I really needed that help,It has been so long since I used this program(since 1990)I forgot how.
This message was edited by cbwidow1 on 2002-10-29 19:50
This message was edited by cbwidow1 on 2002-10-29 19:50

OK i got that part but can you show me what I have to do to get the balance to show how much is really being paid? I dont want to see how much my interest and my house payment together is. I want to see how much is being paid toward the princible when the interest is being add on.I know it is like \$28.28 I`ll do the rest of the caculations later in my program.ty for your help ,I really needed that help,It has been so long since I used this program(since 1990)I forgot how.
This message was edited by cbwidow1 on 2002-10-29 19:51

OK i got that part but can you show me what I have to do to get the balance to show how much is really being paid? I dont want to see how much my interest and my house payment together is. I want to see how much is being paid toward the princible when the interest is being add on.I know it is like \$28.28 I`ll do the rest of the caculations later in my program.ty for your help ,I really needed that help,It has been so long since I used this program(since 1990)I forgot how.
This message was edited by cbwidow1 on 2002-10-29 19:48

Payment - Interest above should give you what your after (col I - Col L)

man a house payment less than 300...whoaaa

The 11% cost of money seems a bit high (in USA anyway)...might try a new bank and refinance.

pll

Trying to but bank wont finance with a 30 year old trailer.
This message was edited by cbwidow1 on 2002-10-29 19:51

Replies
4
Views
255
Replies
2
Views
128
Replies
16
Views
285
Replies
1
Views
286
Replies
7
Views
294

1,203,066
Messages
6,053,330
Members
444,654
Latest member
Rich Cohen

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back