Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from stackoverflow.com Oct 20 '10 at 11:22

This question came from our site for professional and enthusiast programmers.

up vote 2 down vote accepted

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.

share|improve this answer
    
Thank you. That was pretty simple. Haha. – d2jxp Oct 13 '10 at 14:41
    
Glad it helped! – Sohnee Oct 14 '10 at 7:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .