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.
