How do I find missing value?

[edwinvon]

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!

[Otto Moehrbach]

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
"edwinvon" <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>