Specify Excel increments in autofill

[gl4sses]

I'm looking to use excel autofill to complete my formulas in a specific way. My formula is:

=IF(Sheet1!E2<$A$2,$A$2,IF(Sheet1!E2>$A$3,A$3,Sheet1!E2))

I drag down to autofill all instances of E2 --> E3 and so on, as I'd like.

I also want to drag right to make incremental formulae where all instances of A$2 --> B$2 and so on, as well as all instances of E2 --> F2 and so on:

=IF(Sheet1!F2<$B$2,$B$2, IF(Sheet1!F2>$B$3,B$3, Sheet1!F2))

Instead, I get this:

=IF(Sheet1!F2<$A$2,$A$2,IF(Sheet1!F2>$A$3,B$3,Sheet1!F2))

I'm aware that there are some macros that can do this for me, but I'm not very familiar with excel macros and I wouldn't know how to edit them for my specific issue.

Any help would be appreciated, thank you!

 

[jasonb75]

It looks like you just need to remove some of the $ symbols from your formula. If there is a $ symbol then it will not change as you drag it, if there is no $ symbol then it will change.

From the examples you give, I think that you need to change it to

=IF(Sheet1!E2<A$2,A$2,IF(Sheet1!E2>A$3,A$3,Sheet1!E2))