MS Excel HELP - Chicagoland Sportbikes
Chicagoland Sportbikes
 
Geek Squad to the rescue! fucken computer crashing on you again? another porn site infected your computer? tierd of your wife seeing your anal fisting videos and want to lock her out of the external HD? get the answers you need from our local computer experts.

 
LinkBack Thread Tools Display Modes
post #1 of 8 (permalink) Old 12-14-2011, 01:59 PM Thread Starter
Slower Traffic Keep Right
 
stkr's Avatar
 
Join Date: Jun 2005
Location: Kenosha, WI
Posts: 3,755
Location: Kenosha, WI
Sportbike: '06 Suzuki GSXR-750 (Track); '11 HD Electra Glide (Road Sofa)
Years Riding: 30+ yrs total
How you found us: A friend at NESBA
           
MS Excel HELP

Okay, I've got some data in a workbook and I'm trying to figure out the correct formula syntax for this.

Current fx: (simple and works fine)
=VLOOKUP(F3,UnitDividend,2,FALSE)/E3

Wanted:
To evaluate cell E3 and if the value is "Y", then divide the above results by 2. If the value is "N" then just run the original formula.

Either result has to end up in the same cell.

I found the "IF" function, but can't get its syntax correct.

Thanks!


Sent from my iPhone using Tapatalk

Midwest Track Day CR #130
NESBA 130-Control Rider (Former Midwest Region)
STT "A" 130
Track: 2006 GSXR-750
Street: 2011 H-D Ultra Limited (Road Sofa)

www.MidwestTrackDay.com / www.MidwestTrackDay.motorsportreg.com / www.facebook.com/midwesttrackday

http://militarysignatures.com/signatures/member6419.png
stkr is offline  
Sponsored Links
Advertisement
 
post #2 of 8 (permalink) Old 12-14-2011, 02:06 PM
Registered User
 
fenixs's Avatar
 
Join Date: Jul 2011
Location: northwest suburbs
Posts: 83
Location: northwest suburbs
Sportbike: 2011 Ducati 848 EVO
Years Riding: a while
How you found us: my alien abductor
   
I subtituted your "Y" value with 9

=IF(E3=9,E3/2,0)
fenixs is offline  
post #3 of 8 (permalink) Old 12-14-2011, 03:13 PM Thread Starter
Slower Traffic Keep Right
 
stkr's Avatar
 
Join Date: Jun 2005
Location: Kenosha, WI
Posts: 3,755
Location: Kenosha, WI
Sportbike: '06 Suzuki GSXR-750 (Track); '11 HD Electra Glide (Road Sofa)
Years Riding: 30+ yrs total
How you found us: A friend at NESBA
           
Can you group function in the same cell? Is the operation order of the function sequential?


Sent from my iPhone using Tapatalk

Midwest Track Day CR #130
NESBA 130-Control Rider (Former Midwest Region)
STT "A" 130
Track: 2006 GSXR-750
Street: 2011 H-D Ultra Limited (Road Sofa)

www.MidwestTrackDay.com / www.MidwestTrackDay.motorsportreg.com / www.facebook.com/midwesttrackday

http://militarysignatures.com/signatures/member6419.png
stkr is offline  
Sponsored Links
Advertisement
 
post #4 of 8 (permalink) Old 12-14-2011, 03:42 PM
Registered User
 
fenixs's Avatar
 
Join Date: Jul 2011
Location: northwest suburbs
Posts: 83
Location: northwest suburbs
Sportbike: 2011 Ducati 848 EVO
Years Riding: a while
How you found us: my alien abductor
   
You should be able to group a function in the same cell. I use parenthesis to designate the order of operations
fenixs is offline  
post #5 of 8 (permalink) Old 12-14-2011, 03:45 PM Thread Starter
Slower Traffic Keep Right
 
stkr's Avatar
 
Join Date: Jun 2005
Location: Kenosha, WI
Posts: 3,755
Location: Kenosha, WI
Sportbike: '06 Suzuki GSXR-750 (Track); '11 HD Electra Glide (Road Sofa)
Years Riding: 30+ yrs total
How you found us: A friend at NESBA
           
Thanks. I'll work on it later.


Sent from my iPhone using Tapatalk

Midwest Track Day CR #130
NESBA 130-Control Rider (Former Midwest Region)
STT "A" 130
Track: 2006 GSXR-750
Street: 2011 H-D Ultra Limited (Road Sofa)

www.MidwestTrackDay.com / www.MidwestTrackDay.motorsportreg.com / www.facebook.com/midwesttrackday

http://militarysignatures.com/signatures/member6419.png
stkr is offline  
post #6 of 8 (permalink) Old 12-14-2011, 04:43 PM
BSB > WSBK > MotoGP
 
shadrach's Avatar
 
Join Date: May 2004
Location: South Loop & Cary
Posts: 11,948
Location: South Loop & Cary
Sportbike: '02 GSXR 600 / '98 CBRF3
Years Riding: Since '03
How you found us: Google
           
Still need help? I am (or at least was) the VLOOKUP master. I did so many AD migrations using Excel and that little bad-boy named VLOOKUP.

Jeff
NESBA #311
'02 GSXR600
'98
Smokin' Joe's F3
shadrach is offline  
post #7 of 8 (permalink) Old 12-14-2011, 11:39 PM Thread Starter
Slower Traffic Keep Right
 
stkr's Avatar
 
Join Date: Jun 2005
Location: Kenosha, WI
Posts: 3,755
Location: Kenosha, WI
Sportbike: '06 Suzuki GSXR-750 (Track); '11 HD Electra Glide (Road Sofa)
Years Riding: 30+ yrs total
How you found us: A friend at NESBA
           
I'm taking my laptop to the hospital tomorrow and I'll work on it while the wife is in surgery.

Basically the VLOOKUP function works great, but I need to use a different formula on the results if another cell is =Y.


Sent from my iPhone using Tapatalk

Midwest Track Day CR #130
NESBA 130-Control Rider (Former Midwest Region)
STT "A" 130
Track: 2006 GSXR-750
Street: 2011 H-D Ultra Limited (Road Sofa)

www.MidwestTrackDay.com / www.MidwestTrackDay.motorsportreg.com / www.facebook.com/midwesttrackday

http://militarysignatures.com/signatures/member6419.png
stkr is offline  
post #8 of 8 (permalink) Old 12-15-2011, 02:51 PM Thread Starter
Slower Traffic Keep Right
 
stkr's Avatar
 
Join Date: Jun 2005
Location: Kenosha, WI
Posts: 3,755
Location: Kenosha, WI
Sportbike: '06 Suzuki GSXR-750 (Track); '11 HD Electra Glide (Road Sofa)
Years Riding: 30+ yrs total
How you found us: A friend at NESBA
           
I finally got it figured out. Using nested/grouped IF functions. Thanks for the help.

=IF(D57="N",VLOOKUP(F57,UnitsDividend,2)/E57,IF(D57="Y",VLOOKUP(F57,UnitsDividend,2)/E57/2))


Midwest Track Day CR #130
NESBA 130-Control Rider (Former Midwest Region)
STT "A" 130
Track: 2006 GSXR-750
Street: 2011 H-D Ultra Limited (Road Sofa)

www.MidwestTrackDay.com / www.MidwestTrackDay.motorsportreg.com / www.facebook.com/midwesttrackday

http://militarysignatures.com/signatures/member6419.png
stkr is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Chicagoland Sportbikes forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may 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 On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome