Selective increase of numbers when pasting

  • Thread starter Thread starter ayl322
  • Start date Start date
A

ayl322

Hi,
if i have a formula with multiple cell numbers (ex: IF(A1=B1, A1) ) an
i try to copy this formula to multiple cells by dragging from that cel
down, it automatically adds +1 to each number.
so the next ones would read IF(A2=B2, A2), IF (A3=B3, A3), and so on.

How do i make it so only some of the numbers are increased? if i wan
each A cell to compare to B1, i don't want B1 increased, but i want th
A cells increased.

my actual formula is a lot longer, i just picked a simple formula as a
example, but same idea.

Thanks
 
Take a look at "The difference between absolute and relative references"
in XL Help:


=IF(A1=B$1, A1)
 
Back
Top