Hi all!
OK, so I feel a bit out of my depth with a problem I have and I am hoping so much you can help.
I have a finance calculator form I am making, oddly I can do that part!
What I cannot figure out is the formula I need to pop into the form to make it make sense.
I have 3 fields
1 Amount to borrow (user can input this)
2 Interest Rate (User can select this)
3 Length of time to repay (user can select this)
So, what I need to know is something like this, I know it is wrong, I just can't work it out...
[1] x [2] x [3] and that gives me the answer
What I need is the Total amount they will have borrowed over that time period, I have the monthly payments displayed already and that works
Can anyone help with this, it is driving me mad and all the searches I do just give me online calculators, which is the opposite of what I need
Thanks so much in advance!
OK, so I feel a bit out of my depth with a problem I have and I am hoping so much you can help.
I have a finance calculator form I am making, oddly I can do that part!
What I cannot figure out is the formula I need to pop into the form to make it make sense.
I have 3 fields
1 Amount to borrow (user can input this)
2 Interest Rate (User can select this)
3 Length of time to repay (user can select this)
So, what I need to know is something like this, I know it is wrong, I just can't work it out...
[1] x [2] x [3] and that gives me the answer
What I need is the Total amount they will have borrowed over that time period, I have the monthly payments displayed already and that works
Can anyone help with this, it is driving me mad and all the searches I do just give me online calculators, which is the opposite of what I need
Thanks so much in advance!