I want to say in a formula...

If certain cell contains "DMA", then copy over a formula from a cell
immediately to the left, otherwise "".

Is this possible???

Nope.

But formulas could retrieve the value from that other cell:

In z99 (say)
=if(a1="DMA",y99,"No match")


Neese wrote:

I want to say in a formula...

If certain cell contains "DMA", then copy over a formula from a cell
immediately to the left, otherwise "".

Is this possible???

--

Dave Peterson

No - you can't 'copy' in a formula, only 'calculate', though calculations can
do lots of things.



"Neese" wrote:

I want to say in a formula...

If certain cell contains "DMA", then copy over a formula from a cell
immediately to the left, otherwise "".

Is this possible???

On Sep 5, 7:00 am, Neese wrote:
I want to say in a formula...

If certain cell contains "DMA", then copy over a formula from a cell
immediately to the left, otherwise "".

Is this possible???

The others answered this, but I thought I'd add some details, they
were a bit abrupt....

You need to change your understanding of how formulas work and the
terminology. A formula doesn't "copy" or "enter" a value into a cell.
YOU can do that, but a formula can't. A formula will "calculate" and
"return" the proper value. But you need to tell it how.

So, for your question:
The way to do this is to put the formula you want right into your IF
statement, not in a different cell. (unless you really need that
formula in two cells right next to each other, which seems unlikely)
So if your formula is a simple sum:
=IF(A1="DMA",SUM(A2:A10),"")

And try not to double post. If you have to add to your question, use
the same thread.