Copying formula to different cells
 

Have a sheet with 64 rows(accounts) and several columns.
Need to compare two columns and either place an "p" in 3rd column if column
x - column y or "x" if not.

No problem with formula,D3 =IF(C3=B3,"p","x")
but how does one copy the formula without retyping formula in every cell
down 64 rows?

thanks,
L.

Hi
why not copy it. The row index will change automatically

--
Regards
Frank Kabel
Frankfurt, Germany
"L/P" schrieb im Newsbeitrag
...
Have a sheet with 64 rows(accounts) and several columns.
Need to compare two columns and either place an "p" in 3rd column if
column
x - column y or "x" if not.

No problem with formula,D3 =IF(C3=B3,"p","x")
but how does one copy the formula without retyping formula in every cell
down 64 rows?

thanks,
L.

Figured it out, copy that is..

Thanks,

L.



"Frank Kabel" wrote in message
...
Hi
why not copy it. The row index will change automatically

--
Regards
Frank Kabel
Frankfurt, Germany
"L/P" schrieb im Newsbeitrag
...
Have a sheet with 64 rows(accounts) and several columns.
Need to compare two columns and either place an "p" in 3rd column if
column
x - column y or "x" if not.

No problem with formula,D3 =IF(C3=B3,"p","x")
but how does one copy the formula without retyping formula in every cell
down 64 rows?

thanks,
L.