Uzytkownik napisal w wiadomosci
ups.com...
Hi, I have a few hundred of formulas such as this throughout my excel
file: =IF("L2"1,L2,"")

I need to copy/paste these formulas down about 50 rows, Without the
formulas correcting their cell references. Is this possible?

=IF("L2"1,L2,"")
use $l2 or l$2 or $l$2
try all of them and see behaviour of your formulas
u can use F4 to switch between those options ( when L2 in formula is
hihglighted )
mcg