ms excel equation - Great Lakes 4x4. The largest offroad forum in the Midwest

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.

greatlakes4x4.com is the premier Great Lakes 4x4 Forum on the internet. Registered Users do not see the above ads.
Search
Reply
 
Thread Tools Search this Thread
Old March 24th, 2009, 07:24 AM   #1
clarkstoncracker
lol
 
clarkstoncracker's Avatar
 
Join Date: 11-03-05
Location: OC - MI
Posts: 42,616
iTrader: (40)
Mentioned: 131 Post(s)
Send a message via AIM to clarkstoncracker
Default 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
Sponsored Links
Advertisement
 
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)
Mentioned: 1 Post(s)
Default

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
hoo dat. wat.
 
ScOoTeR's Avatar
 
Join Date: 11-09-05
Location: Howell
Posts: 21,579
iTrader: (36)
Mentioned: 10 Post(s)
Default

Holy shit, can I come work for you when I get fired here?
__________________
@clarkstoncracker
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,616
iTrader: (40)
Mentioned: 131 Post(s)
Send a message via AIM to clarkstoncracker
Default

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,616
iTrader: (40)
Mentioned: 131 Post(s)
Send a message via AIM to clarkstoncracker
Default

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)
Mentioned: 0 Post(s)
Default

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,158
iTrader: (7)
Mentioned: 2 Post(s)
Default

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)
Mentioned: 0 Post(s)
Default

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,430
iTrader: (10)
Mentioned: 13 Post(s)
Default

Quote:
Originally Posted by shouldabenacowboy View Post
???????....... 4/4 = 1
Wrong

3/3 = 3
4/4 = 4

This has been covered here multiple times
__________________
#YOLO
#meballsohard
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,159
iTrader: (0)
Mentioned: 0 Post(s)
Default

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 Search this Thread
Search this Thread:

Advanced Search

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 12:10 PM.


Powered by: vBulletin, Copyright 2000 - 2012, Jelsoft Enterprises Ltd.
User Alert System provided by Advanced User Tagging (Lite) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd. Runs best on HiVelocity Hosting.
Page generated in 0.12114 seconds with 50 queries