Simple formula overthinking

[Inquiring_Minds]

I'm working on a checklist for my company. I'm sure I'm overthinking some of this.

I'm trying to find a formula that I can use to determine points/fees out of 100 automatically on the worksheet.
I need this to be for positive and negative numbers
I want to use information keyed in by different cells to auto populate the answer.
D8 (points bought) manually keyed in
B9 (loan amount) manually keyed in
D9 is the total points (D8-100) this should auto populate after keying the points in
D10 is the total costs of the points (D9*B9) this should auto populate after keying the loan amount in
They both should automatically be negative or positive depending on the total points bought, in their own cells

I can make this work (with a simple formula) but it will only return positive (or as a credit), I need mine to be able to do both.

 

[Inquiring_Minds]

@Inquiring_Minds , not everyone here understands mortgage points. You need to explain apple to apples. Points and Mortgage amounts have different decimal positions.

Thank you, I think of these as the same because I've done it for so long.

 

[awoohaw]

what is your expected result in D10 if points are positive on a $100,000 loan? What if points are negative on a $100,000 loan?

 

[etaf]

I'm sorry, i thought it could be the same as a normal math problem, in my mind it is.

no problem
but i did ask a question in previous post
Post 7

 

[awoohaw]

no problem
but i did ask a question in previous post
Post 7

@etaf my question involves that same thing. A point is a value used in financial processes. They are a percentage of some sort. I think he was implying the 100 value was 100 points as well but, I am unsure, so we will have to wait until he provides us with the example I requested.

 

[Candyman8019]

I'm thinking the challenge here is the verbiage "points/fees out of 100" and your formula "D8-100" The formula likely should be D8/100 to give you percentage. Therefore the sheet would look something like this... and if your points are negative, the cost of points is negative.

Book1.xlsm
	A	B	C	D
8	Points Bought			-3
9	Loan Amount	$ 100,000.00		-0.03
10	Total cost of points			(3,000.00)
Sheet12

Cell Formulas
Range	Formula
D9	D9	=+D8/100
D10	D10	=+D9*B9