ExcelBanter - Formula result in different cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula result in different cell (https://www.excelbanter.com/excel-worksheet-functions/118972-formula-result-different-cell.html)

mng

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.

Niek Otten

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.

All times are GMT +1. The time now is 04:40 AM.