I am trying to insert some formulas into a Form I am working on. I have been successful with some formulas so I have a general understanding but currently these seems to be beyond my ability :)
The first one is I am trying to calculate a debt to income ratio where I take my Total Payments divided by my Gross Monthly Income and I would like to yield that at a percentage as seen in my example.
Second is to take a list of possible loan interest discounts and them up with a max of 1% discount then take my posted rate minus my discounts to come up with my final rate and display that at number and 2 digit percentage.
Any help would be greatly appreciated! Thanks