urgent hmwk help..anyone REALLY good with excel?

TranceAddict Forums (www.tranceaddict.com/forums)
- Canada - Toronto & Southern Ont.
-- urgent hmwk help..anyone REALLY good with excel?
Pages (2): [1] 2 »

Posted by NuERA on Jun-28-2006 17:51:

urgent hmwk help..anyone REALLY good with excel?

=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?

Posted by LKD on Jun-28-2006 17:56:

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

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

Posted by NuERA on Jun-28-2006 17:58:

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

Posted by Killah Monkey on Jun-28-2006 17:58:

Re: urgent hmwk help..anyone REALLY good with excel?

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

Posted by NuERA on Jun-28-2006 17:59:

Re: Re: urgent hmwk help..anyone REALLY good with excel?

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

Posted by LKD on Jun-28-2006 18:00:

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

thanks for saving me trouble in the future

Posted by NuERA on Jun-28-2006 18:03:

Re: Re: urgent hmwk help..anyone REALLY good with excel?

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!

Posted by Orko on Jun-28-2006 18:35:

noobs

lol

Posted by DigDeep on Jun-28-2006 18:38:

quote:
Originally posted by Orko
noobs

lol

Posted by DigDeep on Jun-28-2006 18:39:

Re: Re: urgent hmwk help..anyone REALLY good with excel?

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

Posted by TO guy on Jun-28-2006 19:05:

Re: Re: Re: urgent hmwk help..anyone REALLY good with excel?

quote:
Originally posted by Floorwhore
F4 is the shortcut

+ ALT?

Posted by LKD on Jun-28-2006 19:07:

Re: Re: Re: Re: urgent hmwk help..anyone REALLY good with excel?

quote:
Originally posted by TO guy
+ ALT?

only works in the order of ALT + F4

Posted by DigDeep on Jun-28-2006 19:09:

Re: Re: Re: Re: Re: urgent hmwk help..anyone REALLY good with excel?

quote:
Originally posted by El Kay Dee
only works in the order of ALT + F4

uhhh... i just hit F4 and presto.

Posted by TO guy on Jun-28-2006 19:10:

Re: Re: Re: Re: Re: urgent hmwk help..anyone REALLY good with excel?

quote:
Originally posted by El Kay Dee
only works in the order of ALT + F4

I thought math was transitive.

Posted by Killah Monkey on Jun-28-2006 19:13:

Re: Re: Re: urgent hmwk help..anyone REALLY good with excel?

quote:
Originally posted by Floorwhore
F4 is the shortcut

I will never remember that...

I always use the help function when I get stuck with things... the only thing that doesn't work for is when you are trying to hook up your ipod or pda phone...

Posted by LKD on Jun-28-2006 19:15:

Re: Re: Re: Re: Re: Re: urgent hmwk help..anyone REALLY good with excel?

quote:
Originally posted by Floorwhore
uhhh... i just hit F4 and presto.

TO guy wasnt refering to the same shortcut...lol

Posted by TO guy on Jun-28-2006 19:18:

Re: Re: Re: Re: Re: Re: Re: urgent hmwk help..anyone REALLY good with excel?

quote:
Originally posted by El Kay Dee
TO guy wasnt refering to the same shortcut...lol

lol, good times over IRC, watch the noobs drop out of the room

Posted by Platipus on Jun-28-2006 19:25:

lol.. F4 FTW...

GJ Killah, you beat me to it..

Posted by FunkyCrew on Jun-28-2006 19:38:

Re: Re: urgent hmwk help..anyone REALLY good with excel?

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

yeah!
it's basics really

Posted by *~LiSa-LoO~* on Jun-28-2006 19:39:

Holy shit Andrew...I thought you were in DJ school!

Posted by NuERA on Jun-28-2006 23:00:

quote:
Originally posted by *~LiSa-LoO~*
Holy shit Andrew...I thought you were in DJ school!

sound enginerring and thats the forumla to calcuate a 3 surface speaker boundry interference response.

and although i got the equation working its still not giving me the right numbers

Posted by adi26 on Jun-28-2006 23:19:

quote:
Originally posted by NuERA
sound enginerring and thats the forumla to calcuate a 3 surface speaker boundry interference response.

and although i got the equation working its still not giving me the right numbers

You deserve an A just for typing that equation out. I would have dropped that class, course, school.....

Posted by adi26 on Jun-28-2006 23:23:

quote:
Originally posted by *~LiSa-LoO~*
Holy shit Andrew...I thought you were in DJ school!

You called sound engineering DJ School....

Posted by Jem_hadar on Jun-29-2006 00:19:

Re: Re: urgent hmwk help..anyone REALLY good with excel?

quote:
Originally posted by Killah Monkey
if you want to just keep the row constant, put $ in front of the row and vise versa for the column

DAMN! Beat me to it!

I love Excel!

Posted by *~LiSa-LoO~* on Jun-29-2006 01:49:

quote:
Originally posted by NuERA
sound enginerring and thats the forumla to calcuate a 3 surface speaker boundry interference response.

and although i got the equation working its still not giving me the right numbers

oh wow...well sorry I can't help you but good luck Andrew!

Pages (2): [1] 2 »