Formula result in different cell

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Return result of IF logical test in a different cell 1
Multiple Criteria, One Answer 1
How to display result of 3 possible outcomes 3
How to return a blank formula cell if the reference is blank? 2
count - but exclude counting cells with a formula 4
Copy formula down - cell references change - result is same for al 6
Match function: error due to format? 4

Top