=10*LOG10(1+(SIN(4*3.14*E5)/(4*3.14*E5*A2/1130))+(SIN(4*3.14*E6)/(4*3.14*E6*A2/1130))+(SIN(4*3.14*E7)/(4*3.14*E7*A2/1130))+(SIN((4*3.14*SQRT((E6^2)+(E7^2))/(1130/A2)))/(4*3.14*SQRT((E6^2)+(E7^2))*A2/1130)+(SIN((4*3.14*SQRT((E5^2)+(E6^2))/(1130/A2)))/(4*3.14*SQRT((E5^2)+(E6^2))*A2/1130)+(SIN((4*3.14*SQRT((E5^2)+(E7^2))/(1130/A2)))/(4*3.14*SQRT((E5^2)+(E7^2))*A2/1130)+(SIN(4*3.14*SQRT((E5^2)+(E6^2)+(E7^2)))/1130/A2)/(4*3.14*SQRT((E5^2)+(E6^2)+(E7^2))*A2/1130)))))


That is my formula (dont ask)...all i need to know is when i frag the formula down to other cells, how do I keep the E5, E6 and E7 values constant, but update the A2 value to be A3, A4, A5 ect..

It automaticlaly updates the A values but it is also changing the E values to E7, E8, E9, ect and there is no data in those cells, I need it to keep reading the values in E5, E6, and E7 all the time?

Anyone?

___________________
http://soundcloud.com/andrewmcdonell

as far as i know, thers no way out of that....ive tried it before....


unless......i think theres a constant command...lemem check

___________________
www.elkdee.com
Soundcloud sampler: www.soundcloud.com/elkdee

i could go through and change it all manually, but with 18 cells and a formula that long it wouldnt be very fun

___________________
http://soundcloud.com/andrewmcdonell

quote:

Originally posted by NuERA =10*LOG10(1+(SIN(4*3.14*E5)/(4*3.14*E5*A2/1130))+(SIN(4*3.14*E6)/(4*3.14*E6*A2/1130))+(SIN(4*3.14*E7)/(4*3.14*E7*A2/1130))+(SIN((4*3.14*SQRT((E6^2)+(E7^2))/(1130/A2)))/(4*3.14*SQRT((E6^2)+(E7^2))*A2/1130)+(SIN((4*3.14*SQRT((E5^2)+(E6^2))/(1130/A2)))/(4*3.14*SQRT((E5^2)+(E6^2))*A2/1130)+(SIN((4*3.14*SQRT((E5^2)+(E7^2))/(1130/A2)))/(4*3.14*SQRT((E5^2)+(E7^2))*A2/1130)+(SIN(4*3.14*SQRT((E5^2)+(E6^2)+(E7^2)))/1130/A2)/(4*3.14*SQRT((E5^2)+(E6^2)+(E7^2))*A2/1130))))) That is my formula (dont ask)...all i need to know is when i frag the formula down to other cells, how do I keep the E5, E6 and E7 values constant, but update the A2 value to be A3, A4, A5 ect.. It automaticlaly updates the A values but it is also changing the E values to E7, E8, E9, ect and there is no data in those cells, I need it to keep reading the values in E5, E6, and E7 all the time? Anyone?

$E$5 will keep it constant... if you want to just keep the row constant, put $ in front of the row and vise versa for the column

___________________

quote:

Originally posted by Killah Monkey $E$5 will keep it constant... if you want to just keep the row constant, put $ in front of the row and vise versa for the column

hmm ok let me try

___________________
http://soundcloud.com/andrewmcdonell

^^^OMG if only i knew that a year ago...UGH

thanks for saving me trouble in the future

___________________
www.elkdee.com
Soundcloud sampler: www.soundcloud.com/elkdee

quote:

Originally posted by Killah Monkey $E$5 will keep it constant... if you want to just keep the row constant, put $ in front of the row and vise versa for the column

KILLAH MONKEY FTW!

___________________
http://soundcloud.com/andrewmcdonell

Last edited by NuERA on Jun-28-2006 at 19:09

noobs

lol

quote:

Originally posted by Orko noobs lol

___________________
Website / Facebook / Soundcloud

quote:

Originally posted by Killah Monkey $E$5 will keep it constant... if you want to just keep the row constant, put $ in front of the row and vise versa for the column

F4 is the shortcut

___________________
Website / Facebook / Soundcloud

quote:

Originally posted by Floorwhore F4 is the shortcut

+ ALT?

quote:

Originally posted by TO guy + ALT?

only works in the order of ALT + F4

___________________
www.elkdee.com
Soundcloud sampler: www.soundcloud.com/elkdee