*A1-A2/A2, A2-A3/A3, A3-A4/A4...etc. how do i do this for the whol column?
B BenjieLop Nov 23, 2004 #2 Johnny3 said: *A1-A2/A2, A2-A3/A3, A3-A4/A4...etc. how do i do this for the whol column?* Click to expand... If I understand your post correctly, enter this formula in Cell B1 =if(A2="","",(A1-A2)/A2) and copy down as required
Johnny3 said: *A1-A2/A2, A2-A3/A3, A3-A4/A4...etc. how do i do this for the whol column?* Click to expand... If I understand your post correctly, enter this formula in Cell B1 =if(A2="","",(A1-A2)/A2) and copy down as required
J Johnny3 Nov 23, 2004 #4 thank you. you've both saved me about 3 hours of calculations on m TI-30Xa. greatly appreciated and wishing you both a very Happ Thanksgiving
thank you. you've both saved me about 3 hours of calculations on m TI-30Xa. greatly appreciated and wishing you both a very Happ Thanksgiving
