How do I find missing value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

At any time I would need to enter the three values
I have to solve for the fourth.

When I have Margin, Index and rate I will need teaser.

When I have Teaser, Index, and Rate I will need Margin.


Teaser=(INDEX + Margin)-Start rate'

Margin=(Rate + Teaser)-INDEX'

Index=(Rate + Teaser) - Margin

Rate = Will not need to solve for this!
 
What is your question? Are you saying that you have 4 columns labeled
Teaser, Index, Margin, and Rate, and you want to solve for the fourth one
given the other 3? Please post back and clarify what you want/need. HTH
Otto
 
Back
Top