copy formula as is to new cell in an if statement

N

Neese

ing B C
D
1 Albany Ga 0034 Albany, Ga 3,445 3445
2 Albany Ga 0739 Tifton, Ga 2,488 1445
3 Total DMA 2,967 (avg of cells above)

I want to add a column "E" to the right that says if A3 has "DMA", then copy
formula in D3 over to E3, otherwise "". Does this make sense? Also, I'm
averaging many different numbers of rows at a time, so I just can't copy the
average formula down. can someone help?
 
B

Bob Bridges

Looks like part of your post got cut off, but answering based on what I can
see here, I'd say this is really simple -- so simple that maybe I've
misunderstood the question. Try this:

=IF(A3="DMA",D3,"")

This IF function displays the contents (the value, not the formula) of D3 if
A3's contents (the value again) is "DMA"; otherwise it displays "". If that
isn't exactly what you wanted, then maybe the part of your post that vanished
has some relevant information.
 

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

Can I use copy function in an if statement? 3
Formula question 2
Average formula only works partially..... 6
Use cell contents to refer to a sheetname in a formula 6
How do I not count cells that have formulas in them 2
How to do an IF statement that copy data based on a partial match 0
Looking to added up based on a character from cell range 1
Weighted ranking of a series 3

Top