by strollin » Wed Oct 03, 2012 6:41 am
This isn't the best forum to ask that question but here is a possible solution:
Assuming the cell where the age is entered is A1 and the cell where you want to indicate whether or not the person is a senior is D1 (3 columns over) then the formula for D1 would be "=IF(A1>=60,"Y","N")" (leave off the outer "s). If you need to replicate this over many rows in your spreadsheet then select cell D1 and press Ctrl-C, then select cell D2 and drag your mouse down as many rows as needed and press Ctrl-V. This will copy the formula to all those rows but Excel is smart enough to update formula to look at the appropriate cell. For example, in D2 it will change to "=IF(A2>=60,"Y","N")", likewise D3's formula will evaluate A3, etc...