Autofill Function Problems

[hhjj]

Hello all,

I'm trying to create formula that I can use to autofill rows on my table with a formula that changes incrementally. I want the formula to fill the row with figures taken from a column on a separate page, and also to replace all 0 values with "-" so that they don't interfere with any other averages. I have this formula which seems to work for an individual cell:

=IF(0 = Page2!I5,"-",Page2!I5)

However, when I use the autofill handle to drag it along the row, it changes the references to Page2!J5, Page2!K5 and so on. As it's a column that I need to make into a row, I need the reference to change to Page2!I6, Page2!I7 and so on... any ideas?

Thanks,
H

[José Augusto]

Hi
Try using

Please Login or Register  to view this content.

and drag to right

[hhjj]

This worked perfectly, thank you so much! What a terrifying formula for something I thought would be so simple...


H

[José Augusto]

You are welcomed.