not sure what formula to use

M

mark petrak

trying to make it do this

lets say that cell a1 has an account number and a2 has nothing, when a
ammount is placed in cell a2 i want cell C3 to have a1's account numbe
and cell c4 to have the amount in a2

i have to do this for about 100 cells, so i dont think i can use IF.

any help would be great,

thanks
Mar
 
C

Cutter

In C3 type: =IF(A2<>"",A1,"")
In C4 type: =IF(A2<>"",A2,"")

Without knowing your layout for other cells to copy to I can't advise
as to Absolute Referencing but bear it in mind when adapting it to your
needs.
 
M

mark petrak

more info

ok if B34 has an ammount then i want B28 to have what is in A34, an
C28 to have the ammount in B34

than it goes down a list with the number of the cells increasin
 
C

Cutter

In B28 type: =IF(B34<>"",A34,"")
In C28 type: =IF(B34<>"",B34,"")

If you want the formulas to go down the list in each cell then jus
drag copy the formulas down as far as you need

Or if you want to put the formulas into non-adjacent cells below the
you'll have to Copy-Paste them
 
Top