Formula result in different cell

M

mng

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.
 
N

Niek Otten

In A1:
=IF(YourCondition,Outcome,"")
In C1:
=IF(YourCondition,"",Outcome)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.
 
Top