if function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

can any one help with these if functions

a1
=if(c1=2,c2,original value of a1)
a2
=if(c1=3,c2,original value of a2)
a3
=if(c1=4,c2,original value of a3)
a4
=if(c1=5,c2,original value of a4)

the original value of each cell will be 0
the value of c1 and c2 will be entered automatically using a macro

the original value of a1 will be
 
Since "the original value of each cell will be 0":


A1: =IF(C1=2,C2,0)
A2: =IF(C1=3,C2,0)
A3: =IF(C1=4,C2,0)
A5: =IF(C1=5,C2,0)
 
what happens if i then run the sequence a second, third or fouth time it will re set the first line value to 0
what i was looking for was something like this
ORIGNAL PASS 1 pass2 pass3 pass4
a1 0 a1 10 a1 10 a1 10 a1 10
a2 0 a2 0 a2 13 a2 13 a2 10
a3 0 a3 0 a3 0 a3 7 a3 7
a4 0 A4 0 a4 0 a4 0 a4 39

is there a way of make the false value keep the existing cell value

Ps. thanks for replying to my first post
 
Back
Top