Go Back   Great Lakes 4x4. The largest offroad forum in the Midwest > General 4x4 Stuff > The Pub
GL4x4 Live! GL4x4 Casino

The Pub A friendly forum where everybody is nice, and will answer any questions you have about life.







Search
Reply
 
Thread Tools
Old March 24th, 2009, 07:24 AM   #1
clarkstoncracker
lol
 
clarkstoncracker's Avatar
 
Join Date: 11-03-05
Location: OC - MI
Posts: 42,013
iTrader: (39)
Send a message via AIM to clarkstoncracker
ms excel equation

i'm pretty spreadsheet stupid.

I need my column F to do the following (repeated down 12 rows)

(Column B x .97)-132


thanks
__________________
clarkstoncracker is offline   Reply With Quote
Old March 24th, 2009, 07:28 AM   #2
BMFmike
meh.
 
BMFmike's Avatar
 
Join Date: 11-06-05
Location: Grand Haven
Posts: 7,816
iTrader: (6)
Do you just need to do the column B that is in the same row as the equation taking place in column F? If so just click on the first cell in column B when making the equation.

=(B1*.97)-132

then click and drag.

If you want it to stay the same number but refer to B1 if it is changing --> $B$1 (I think)
BMFmike is offline   Reply With Quote
Old March 24th, 2009, 07:28 AM   #3
ScOoTeR
GLFWDA Member #07520
 
ScOoTeR's Avatar
 
Join Date: 11-09-05
Location: Howell
Posts: 21,222
iTrader: (35)
Holy shit, can I come work for you when I get fired here?
ScOoTeR is offline   Reply With Quote
Old March 24th, 2009, 07:31 AM   #4
clarkstoncracker
lol
 
clarkstoncracker's Avatar
 
Join Date: 11-03-05
Location: OC - MI
Posts: 42,013
iTrader: (39)
Send a message via AIM to clarkstoncracker
rock on. thanks man.
__________________
clarkstoncracker is offline   Reply With Quote
Old March 24th, 2009, 07:32 AM   #5
clarkstoncracker
lol
 
clarkstoncracker's Avatar
 
Join Date: 11-03-05
Location: OC - MI
Posts: 42,013
iTrader: (39)
Send a message via AIM to clarkstoncracker
Quote:
Originally Posted by ScOoTeR View Post
Holy shit, can I come work for you when I get fired here?
normally I don't have to do this kind of busy work jackass.


__________________
clarkstoncracker is offline   Reply With Quote
Old March 24th, 2009, 07:38 AM   #6
steveo
In the band!
 
Join Date: 03-30-07
Location: montana/wyoming
Posts: 20,293
iTrader: (6)
all i know is 4/4=4
steveo is offline   Reply With Quote
Old March 24th, 2009, 08:36 AM   #7
Cube
Captain of my pants
 
Cube's Avatar
 
Join Date: 11-06-05
Location: Traverse City
Posts: 4,154
iTrader: (7)
hehe who is the excel guru here anyways, I have some questions time to time, can we have a GL, work questions sections, yesssssssssssss
Cube is offline   Reply With Quote
Old March 24th, 2009, 08:37 AM   #8
shouldabenacowboy
Hope and Change?
 
shouldabenacowboy's Avatar
 
Join Date: 06-29-08
Location: Marysville
Posts: 933
iTrader: (4)
Quote:
Originally Posted by steveo View Post
all i know is 4/4=4

???????....... 4/4 = 1
shouldabenacowboy is offline   Reply With Quote
Old March 24th, 2009, 08:40 AM   #9
Sol Goode
Obama Nation!
 
Sol Goode's Avatar
 
Join Date: 11-05-05
Location: Curt1656 & Scooters love castle
Posts: 14,107
iTrader: (10)
Quote:
Originally Posted by shouldabenacowboy View Post
???????....... 4/4 = 1
Wrong

3/3 = 3
4/4 = 4

This has been covered here multiple times
__________________
Come roll with us........
Sol Goode is offline   Reply With Quote
Old March 24th, 2009, 09:16 AM   #10
Just a Spouse
Motrcytman's spouse
 
Just a Spouse's Avatar
 
Join Date: 11-05-05
Location: Lake View, AL
Posts: 7,117
iTrader: (0)
Quote:
Originally Posted by steveo View Post
all i know is 4/4=4
LMAO!!
Just a Spouse is offline   Reply With Quote
Reply
Great Lakes 4x4. The largest offroad forum in the Midwest > General 4x4 Stuff > The Pub
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT -5. The time now is 08:50 PM.


Powered by: vBulletin, Copyright 2000 - 2012, Jelsoft Enterprises Ltd.
Copyright 2005 - 2012 Cracker Enterprises - Powered by Linux
vB Ad Management by =RedTyger=
Page generated in 0.09734 seconds with 30 queries