software

I'd like to do the following:

=IF(A1=10, B1=quot;Rightquot;, quot;Leftquot;)

If not IF, then how?

Thanks.
Formula results show up in the cell where the formula is located. BUT, they
can (and usually do) take other cells as inputs.
So put the formula in cell B1 (where you want the result):
=if(a1=10,quot;Rightquot;,quot;Leftquot;)

quot;Ricterquot; wrote:

gt; I'd like to do the following:
gt;
gt; =IF(A1=10, B1=quot;Rightquot;, quot;Leftquot;)
gt;
gt; If not IF, then how?
gt;
gt; Thanks.
gt;
gt;

Well, unfortunately, if I put the formula in B1, then I'll want it to change
the value of cell C1 if A1=x...

Sounds like it can't be done, at least not with IF.
quot;bpeltzerquot; wrote:

gt; Formula results show up in the cell where the formula is located. BUT, they
gt; can (and usually do) take other cells as inputs.
gt; So put the formula in cell B1 (where you want the result):
gt; =if(a1=10,quot;Rightquot;,quot;Leftquot;)
gt;
gt; quot;Ricterquot; wrote:
gt;
gt; gt; I'd like to do the following:
gt; gt;
gt; gt; =IF(A1=10, B1=quot;Rightquot;, quot;Leftquot;)
gt; gt;
gt; gt; If not IF, then how?
gt; gt;
gt; gt; Thanks.
gt; gt;
gt; gt;