| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula result in different cell
How can I place the result of an 'if then' statement in a different cell than
where the formula was written. for example, if I have a formula in cell a1 and depending on the outcome of the if/then statement, I may want ot put the result in a1 or I may want the result to be in c1. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula result in different cell
In A1:
=IF(YourCondition,Outcome,"") In C1: =IF(YourCondition,"",Outcome) -- Kind regards, Niek Otten Microsoft MVP - Excel "mng" wrote in message ... | How can I place the result of an 'if then' statement in a different cell than | where the formula was written. for example, if I have a formula in cell a1 | and depending on the outcome of the if/then statement, I may want ot put the | result in a1 or I may want the result to be in c1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell shows formula eg ='Sheet21'!F3 instead of result | Excel Worksheet Functions | |||
| Formula displays result in formula box but not in cell | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
