Formula result in different cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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