Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return result of IF logical test in a different cell
Is there a way to return the result of an IF logical test in a cell OTHER
than the cell that the formula is typed in? For example, if A1 = apples and I want to check this using an IF statement in C1 I write =IF(A1="apples" ,"yes"), but I want "yes" to appear in B1, not C1. Is this possible? I tried C1 =IF(A1="apples" , B1="yes")...but no luck. This is driving me absolutely crazy, since I'm sure there must be a way to do this. So any input will be much appreciated. Thanks!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return result of IF logical test in a different cell
in C1 I write =IF(A1="apples" ,"yes"),
but I want "yes" to appear in B1 Is this possible? No. You'd have to put the formula in cell B1. A formula can only produce a result in the cell that contains the formula. A formula can't "push" a result to another cell. -- Biff Microsoft Excel MVP "navyraine" wrote in message ... Is there a way to return the result of an IF logical test in a cell OTHER than the cell that the formula is typed in? For example, if A1 = apples and I want to check this using an IF statement in C1 I write =IF(A1="apples" ,"yes"), but I want "yes" to appear in B1, not C1. Is this possible? I tried C1 =IF(A1="apples" , B1="yes")...but no luck. This is driving me absolutely crazy, since I'm sure there must be a way to do this. So any input will be much appreciated. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL 2000 - IF function returns wrong result from logical test | Excel Worksheet Functions | |||
logical test for an #N/A condition in a cell | Excel Discussion (Misc queries) | |||
Logical test in IF statement returning incorrect result | Excel Worksheet Functions | |||
Logical test if cell uses formatting.. | Excel Worksheet Functions | |||
logical test for each and every cell in range | Excel Discussion (Misc queries) |