Getbig.com: American Bodybuilding, Fitness and Figure

Getbig Main Boards => Gossip & Opinions => Topic started by: Roger Bacon on February 27, 2012, 12:14:25 PM

Title: Excel Help Please
Post by: Roger Bacon on February 27, 2012, 12:14:25 PM
I'm working on excel.

I need a certain cell to tell me how many times I need to multiply a different cell to equal another cell.

How would I do that?

Example:

Cell A1
Average Unit Sale Price = $100

Cell A2
Sales Goal = 230

Cell A3
Sales Needed = ??? (Something like) Cell A1*my answer for this cell=Cell A2???
Title: Re: Excel Help Please
Post by: GraniteCityDon on February 27, 2012, 12:18:25 PM
Something this simple can be tricky for new users, i would suggest:

Cell A3 = Cell A2/ Cell A1 - formatted to 1 decimal place for specifics or 0 decimal places for whole units.
Title: Re: Excel Help Please
Post by: Grape Ape on February 27, 2012, 12:25:49 PM
Correct.

=a2/a1
Title: Re: Excel Help Please
Post by: Man of Steel on February 27, 2012, 12:28:18 PM
Coming to Getbig for excel help LOL!!! 
Title: Re: Excel Help Please
Post by: Roger Bacon on February 27, 2012, 12:29:49 PM
Coming to Getbig for excel help LOL!!! 

haha!! Don't laugh!

The two brilliant gettbiggers that answered before you nailed it!

Getbig=smartest group on average in the world, and I mean that!
Title: Re: Excel Help Please
Post by: Grape Ape on February 27, 2012, 12:32:12 PM
Feel free to PM me with any Excel issues you may have.
Title: Re: Excel Help Please
Post by: El Diablo Blanco on February 27, 2012, 12:34:01 PM
According to GH15.  To solve your problem.

100 mg test ED
100 mg Tren Acetato ED
50 mg Masterona ED
100 mg primobologna ED.

This should help your excela
Title: Re: Excel Help Please
Post by: Voland on February 27, 2012, 12:34:33 PM
haha!! Don't laugh!

The two brilliant gettbiggers that answered before you nailed it!

Getbig=smartest group on average in the world, and I mean that!


thats why getbiggers are all CEOs and date super models.  8)
Title: Re: Excel Help Please
Post by: Roger Bacon on February 27, 2012, 12:37:05 PM
thats why getbiggers are all CEOs and date super models.  8)

So TRUE!!!  ;D

According to GH15.  To solve your problem.

100 mg test ED
100 mg Tren Acetato ED
50 mg Masterona ED
100 mg primobologna ED.

This should help your excela

Now that's the answer I was looking for!!!!  8)
Title: Re: Excel Help Please
Post by: wes on February 27, 2012, 12:39:48 PM
thats why getbiggers are all CEOs and date super models.  8)
Fucking right...........we all know we can solve any worldly problem by just asking the brainiacs on getbig for advice on nearly any subject.

Gotta` run,my two supermodels are getting impatient!  ;)
Title: Re: Excel Help Please
Post by: Grape Ape on February 27, 2012, 12:46:54 PM
Gotta` run,my two supermodels are getting impatient!  ;)

Alpha up man!   Make 'em wait.
Title: Re: Excel Help Please
Post by: basil on February 27, 2012, 12:51:59 PM
Coming to Getbig for excel help LOL!!! 

He got an answer in the first reply.
Title: Re: Excel Help Please
Post by: wes on February 27, 2012, 12:53:38 PM
Alpha up man!   Make 'em wait.
You`re right,what was I thinking ?  ;D
Title: Re: Excel Help Please
Post by: Man of Steel on February 27, 2012, 02:21:42 PM
He got an answer in the first reply.

I think y'all are missing the point LOL!! 
Title: Re: Excel Help Please
Post by: DroppingPlates on February 27, 2012, 02:27:37 PM
Menubar > Tools > Goal seek

Hope this helps

Title: Re: Excel Help Please
Post by: Roger Bacon on February 27, 2012, 09:14:45 PM
Something this simple can be tricky for new users, i would suggest:

Cell A3 = Cell A2/ Cell A1 - formatted to 1 decimal place for specifics or 0 decimal places for whole units.
Correct.

=a2/a1

You two nailed this, and I have no idea how because I just read my post and I cant even understand it now.  ;D
Title: Re: Excel Help Please
Post by: Roger Bacon on February 27, 2012, 09:19:07 PM
Menubar > Tools > Goal seek

Hope this helps



Cool, thanks.... Didn't even know about that
Title: Re: Excel Help Please
Post by: HTexan on February 27, 2012, 09:57:31 PM
Coming to Getbig for excel help LOL!!!  
i used to teach computers, including office, to kids in summer school until my college cut funding. funny thing,  kids could rock the fuck out of  word and power point but couldn't used excel to save their lives.