| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if one cell were to equal __ what would the value in another cell
Hi,
please could you provide with more information but an starts =if(a1=10,your formula) "uldk" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if one cell were to equal __ what would the value in another cell
Not too clear:
="If A1 = 10 then A1+B1 would be " & Text(10+B1,"#.00") best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "uldk" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
| Compare two cells, if equal move a third cell to another cell | Excel Discussion (Misc queries) | |||
| How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
