I have a spreadsheet I'm putting together that calulates values for a row of cells based on values of other cells using a formula.
I want to use the autofill feature in excell 2007 to fill in the values for this row. However when I try and do this is doesnt increment the numberical value in the formula only the letter.
e.g.
=IF(Organisation!F5="Not Applicable","N/A",(Organisation!F5)) is the formula in the first cell of the row.
If I use the series fill feature to drag this accross the rest of the cells it does this :
=IF(Organisation!F5="Not Applicable","N/A",(Organisation!F5))
=IF(Organisation!G5="Not Applicable","N/A",(Organisation!G5))
=IF(Organisation!H5="Not Applicable","N/A",(Organisation!H5))
=IF(Organisation!I5="Not Applicable","N/A",(Organisation!I5)) etc. when what I want is:
=IF(Organisation!F5="Not Applicable","N/A",(Organisation!F5))
=IF(Organisation!F6="Not Applicable","N/A",(Organisation!F6))
=IF(Organisation!F7="Not Applicable","N/A",(Organisation!F7))
=IF(Organisation!F8="Not Applicable","N/A",(Organisation!F8)) etc.
I've played with all the series fill options but can't get it to behave the way I want?
Anyone know how to do it, before I resort to editing it all by hand?
I want to use the autofill feature in excell 2007 to fill in the values for this row. However when I try and do this is doesnt increment the numberical value in the formula only the letter.
e.g.
=IF(Organisation!F5="Not Applicable","N/A",(Organisation!F5)) is the formula in the first cell of the row.
If I use the series fill feature to drag this accross the rest of the cells it does this :
=IF(Organisation!F5="Not Applicable","N/A",(Organisation!F5))
=IF(Organisation!G5="Not Applicable","N/A",(Organisation!G5))
=IF(Organisation!H5="Not Applicable","N/A",(Organisation!H5))
=IF(Organisation!I5="Not Applicable","N/A",(Organisation!I5)) etc. when what I want is:
=IF(Organisation!F5="Not Applicable","N/A",(Organisation!F5))
=IF(Organisation!F6="Not Applicable","N/A",(Organisation!F6))
=IF(Organisation!F7="Not Applicable","N/A",(Organisation!F7))
=IF(Organisation!F8="Not Applicable","N/A",(Organisation!F8)) etc.
I've played with all the series fill options but can't get it to behave the way I want?
Anyone know how to do it, before I resort to editing it all by hand?
Comment