if one cell were to equal __ what would the value in another cell

Posted to microsoft.public.excel.worksheet.functions

uldk

external usenet poster

Posts: 1

if one cell were to equal __ what would the value in another cell

Suppose

A1 = 5
B1 = 10
C1 = a1+b1

Can you put a formula in a cell that would say that if a1 were to be 10 and
have it display then what would the value in c1 be.

I need this for something much more complex than this but this is the
general idea.

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
can I make cell "yes" equal 1, "no" equal 0	can I make cell yes equal 1, no equa	Excel Discussion (Misc queries)	4	April 22nd 23 06:09 AM
Compare two cells, if equal move a third cell to another cell	Mike	Excel Discussion (Misc queries)	3	December 30th 08 07:26 PM
How to point to (select) a cell to the left from a cell where I enter the = equal sign?	Dmitry	Excel Discussion (Misc queries)	4	June 30th 06 06:49 AM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 7th 04 10:50 PM

All times are GMT +1. The time now is 05:06 AM.

Menu

About Us