| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"If"
I would like to add the "if" formula into one cell but obtain the results in
another one. is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If"
Hi,
In short no because formula cannot push values out they can only pull values in. You could do it with another formula in the 'other' cell or with VB but more detail is required -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Bib" wrote: I would like to add the "if" formula into one cell but obtain the results in another one. is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"If"
On Mon, 8 Feb 2010 04:26:01 -0800, Bib wrote:
I would like to add the "if" formula into one cell but obtain the results in another one. is this possible? A1: =IF(your_formula) Some other cell: =A1 The IF formula itself, or any formula, for that matter, can only return a value. It cannot alter a different cell. If the contents of the other cell MUST be a text string, you should be able to do that with a VBA Macro. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
