Author Topic: Excel Help Please  (Read 2832 times)

Roger Bacon

  • Getbig V
  • *****
  • Posts: 20957
  • Roger Bacon tries to be witty and fails
Excel Help Please
« 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???

GraniteCityDon

  • Getbig IV
  • ****
  • Posts: 1555
Re: Excel Help Please
« Reply #1 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.

Grape Ape

  • Getbig V
  • *****
  • Posts: 22546
  • SC è un asino
Re: Excel Help Please
« Reply #2 on: February 27, 2012, 12:25:49 PM »
Correct.

=a2/a1
Y

Man of Steel

  • Getbig V
  • *****
  • Posts: 19391
  • Isaiah40:28-31 ✝ Romans10:9 ✝ 1Peter3:15
Re: Excel Help Please
« Reply #3 on: February 27, 2012, 12:28:18 PM »
Coming to Getbig for excel help LOL!!! 

Roger Bacon

  • Getbig V
  • *****
  • Posts: 20957
  • Roger Bacon tries to be witty and fails
Re: Excel Help Please
« Reply #4 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!

Grape Ape

  • Getbig V
  • *****
  • Posts: 22546
  • SC è un asino
Re: Excel Help Please
« Reply #5 on: February 27, 2012, 12:32:12 PM »
Feel free to PM me with any Excel issues you may have.
Y

El Diablo Blanco

  • Getbig V
  • *****
  • Posts: 31828
  • Nom Nom Nom Nom
Re: Excel Help Please
« Reply #6 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

Voland

  • Time Out
  • Getbig IV
  • *
  • Posts: 2620
  • when you go scat you never come back ;)
Re: Excel Help Please
« Reply #7 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)
Boundary Breaker

Roger Bacon

  • Getbig V
  • *****
  • Posts: 20957
  • Roger Bacon tries to be witty and fails
Re: Excel Help Please
« Reply #8 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)

wes

  • Competitors
  • Getbig V
  • *****
  • Posts: 66416
  • What Dire Mishap Has Befallen Thee
Re: Excel Help Please
« Reply #9 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!  ;)

Grape Ape

  • Getbig V
  • *****
  • Posts: 22546
  • SC è un asino
Re: Excel Help Please
« Reply #10 on: February 27, 2012, 12:46:54 PM »
Gotta` run,my two supermodels are getting impatient!  ;)

Alpha up man!   Make 'em wait.
Y

basil

  • Getbig IV
  • ****
  • Posts: 1180
Re: Excel Help Please
« Reply #11 on: February 27, 2012, 12:51:59 PM »
Coming to Getbig for excel help LOL!!! 

He got an answer in the first reply.

wes

  • Competitors
  • Getbig V
  • *****
  • Posts: 66416
  • What Dire Mishap Has Befallen Thee
Re: Excel Help Please
« Reply #12 on: February 27, 2012, 12:53:38 PM »
Alpha up man!   Make 'em wait.
You`re right,what was I thinking ?  ;D

Man of Steel

  • Getbig V
  • *****
  • Posts: 19391
  • Isaiah40:28-31 ✝ Romans10:9 ✝ 1Peter3:15
Re: Excel Help Please
« Reply #13 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!! 

DroppingPlates

  • Competitors II
  • Getbig V
  • *****
  • Posts: 49987
  • Team Pocahontas
Re: Excel Help Please
« Reply #14 on: February 27, 2012, 02:27:37 PM »
Menubar > Tools > Goal seek

Hope this helps


Roger Bacon

  • Getbig V
  • *****
  • Posts: 20957
  • Roger Bacon tries to be witty and fails
Re: Excel Help Please
« Reply #15 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

Roger Bacon

  • Getbig V
  • *****
  • Posts: 20957
  • Roger Bacon tries to be witty and fails
Re: Excel Help Please
« Reply #16 on: February 27, 2012, 09:19:07 PM »
Menubar > Tools > Goal seek

Hope this helps



Cool, thanks.... Didn't even know about that

HTexan

  • Getbig V
  • *****
  • Posts: 20031
  • Heath must lose!!
Re: Excel Help Please
« Reply #17 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.
A