I need to apply the formula =IF(Fx-TODAY()<0,"EXPIRED",Fx-TODAY()) to each row in an Excel column where x is the number of the row that the formula is in. I have a lot of rows, upwards of 100. How can I do this without manually setting each the formula for each row?
|
feedback
|
migrated from stackoverflow.com Oct 20 '10 at 11:22
This question came from our site for professional and enthusiast programmers.
|
If you set it on the first row, then drag the corner of the cell downwards, Excel will automatically adjust the formula for each row. | |||||
feedback
|
