software

Is there any way to show the results of an IF formula in a seperate cell. So
the formula is in A1 but I want to show the results in D3?

Hi

You could format the A1 to have white text and in D3 type =A1

Andy.

quot;lt73quot; gt; wrote in message
...
gt; Is there any way to show the results of an IF formula in a seperate cell.
gt; So
gt; the formula is in A1 but I want to show the results in D3?
Change the format of Cell A1 to Text, and type in the formula. Now Cell A1
will show the formula.

For Cell D3, change the format to General, and type in the formula. Now
Cell D3 will show the result, instead of showing the formula.

I hope that's what you want.

quot;lt73quot; wrote:

gt; Is there any way to show the results of an IF formula in a seperate cell. So
gt; the formula is in A1 but I want to show the results in D3?