View Single Post
  #1   Report Post  
L/P
 
Posts: n/a
Default 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.