Posted to microsoft.public.excel.programming

edwinvon

external usenet poster

Posts: 2

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'

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Missing text in cells	C Petrie	Excel Discussion (Misc queries)	1	March 3rd 08 07:56 AM
Pie Charting with Missing and Changing Data	ksp	Charts and Charting in Excel	5	May 30th 06 10:46 AM
Missing Cells	nurato4e	Excel Discussion (Misc queries)	0	December 8th 05 10:16 PM
assigning "missing value" to cells	Clare	Excel Discussion (Misc queries)	1	March 9th 05 08:34 PM
Missing cells	DaSo	Excel Programming	4	January 27th 05 12:54 PM

All times are GMT +1. The time now is 06:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us