|
P.I.P
|
 |
« on: February 27, 2012, 01: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
|
|
« Reply #1 on: February 27, 2012, 01: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
|
|
« Reply #2 on: February 27, 2012, 01:25:49 PM » |
|
Correct.
=a2/a1
|
A
|
|
|
|
Man of Steel
|
|
« Reply #3 on: February 27, 2012, 01:28:18 PM » |
|
Coming to Getbig for excel help LOL!!!
|
|
|
|
|
|
P.I.P
|
|
« Reply #4 on: February 27, 2012, 01: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
|
|
« Reply #5 on: February 27, 2012, 01:32:12 PM » |
|
Feel free to PM me with any Excel issues you may have.
|
A
|
|
|
|
El Diablo Blanco
|
|
« Reply #6 on: February 27, 2012, 01: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: 2628
when you go scat you never come back ;)
|
|
« Reply #7 on: February 27, 2012, 01: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.  |
Boundary Breaker
|
|
|
|
P.I.P
|
|
« Reply #8 on: February 27, 2012, 01:37:05 PM » |
|
thats why getbiggers are all CEOs and date super models. So TRUE!!!  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!!!! |
☩
|
|
|
wes
Competitors
Getbig V
Gender: 
Posts: 20358
Fuck That Noise
|
|
« Reply #9 on: February 27, 2012, 01:39:48 PM » |
|
thats why getbiggers are all CEOs and date super models. 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!  |
TEAM NOGGIN
|
|
|
|
Grape Ape
|
|
« Reply #10 on: February 27, 2012, 01:46:54 PM » |
|
Gotta` run,my two supermodels are getting impatient! Alpha up man! Make 'em wait. |
A
|
|
|
|
basil
|
|
« Reply #11 on: February 27, 2012, 01:51:59 PM » |
|
Coming to Getbig for excel help LOL!!!
He got an answer in the first reply. |
|
|
|
|
wes
Competitors
Getbig V
Gender:
Posts: 20358
Fuck That Noise
|
|
« Reply #12 on: February 27, 2012, 01:53:38 PM » |
|
Alpha up man! Make 'em wait.
You`re right,what was I thinking ? |
TEAM NOGGIN
|
|
|
|
Man of Steel
|
|
« Reply #13 on: February 27, 2012, 03:21:42 PM » |
|
He got an answer in the first reply.
I think y'all are missing the point LOL!! |
|
|
|
|
|
DroppingPlates
|
|
« Reply #14 on: February 27, 2012, 03:27:37 PM » |
|
Menubar > Tools > Goal seek Hope this helps |
|
|
|
|
|
P.I.P
|
|
« Reply #15 on: February 27, 2012, 10: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. |
☩
|
|
|
|
P.I.P
|
|
« Reply #16 on: February 27, 2012, 10:19:07 PM » |
|
Menubar > Tools > Goal seek Hope this helps Cool, thanks.... Didn't even know about that |
☩
|
|
|
|
HTexan
|
|
« Reply #17 on: February 27, 2012, 10: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. |
Allegedly.
|
|
|
|
