| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy formula as is to new cell in an if statement
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement in cell formula | Excel Worksheet Functions | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| If Statement Checking Formula NOT Value in a Cell | Excel Discussion (Misc queries) | |||
| Copy exact value from one cell to new formula in another cell | Excel Discussion (Misc queries) | |||
Threaded Mode
