View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
edwinvon edwinvon is offline
external usenet poster
 
Posts: 2
Default How do I solve for missing value of changing cells?

I have 4 values - Rate, Index, Margin & Teaser. If I have 3 of the four I can
solve for any of them when they are missing. How do I create this to allow
input of values to solve for the missing value regardless of which one is
missing? 'Teaser= (Index + Margin)-rate', Index=(rate + Teaser) - Margin, and
Margin= (Rate + Teaser) - Index'