Formula Mass Copy???

O

onesidered

Is there a way to copy a formula to an entire column?

My example formula...

=IF(C5>F9,"Suspended","")

The value of F9 is 2


The formula either needs to recall F9 each time, or just have a way to
say =IF(this cell)>2 ,"suspended","")

Thanx,
T.
 
S

swatsp0p

Assuming your formula is in a cell adjacent to your data, simply hove
the mouse over the lower right corner until it changes to a plus sig
then double click. This will copy your formula (or whatever th
contents of the cell are) down to the end of the data in the adjacen
column. If it is not adjacent to data in another column, you can clic
and drag the grab handle (the small square in the lower right corner o
the cell) down as far as you need.

You may want to fix the cell reference in your formula BEFORE doin
this, however, so that you continue to compare to cell F9 as such:

=IF(C5>$F$9,"Suspended","") when dragged down one cell will read:
=IF(C6>$F$9,"Suspended","")

HTH

Bruc
 
Top