E46 BMW Social Directory E46 FAQ 3-Series Discussion Forums BMW Photo Gallery BMW 3-Series Technical Information E46 Fanatics - The Ultimate BMW Resource BMW Vendors General E46 Forum The Tire Rack's Tire Wheel Forum Forced Induction Forum The Off-Topic The E46 BMW Showroom For Sale, For Trade or Wanting to Buy

Welcome to the E46Fanatics forums. E46Fanatics is the premiere website for BMW 3 series owners around the world with interactive forums, a geographical enthusiast directory, photo galleries, and technical information for BMW enthusiasts.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Go Back   E46Fanatics > Everything Else > The Off-Topic > General Off-Topic

General Off-Topic
Everything not about BMWs. Posts must be "primetime" safe and in good taste. You must be logged in to see sub-forums.
Click here to browse all new posts.

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 04-18-2017, 08:17 AM   #1
MpoweredM
Wants to be Orange
 
MpoweredM's Avatar
 
Join Date: Sep 2004
Location: Washington DC
Posts: 13,307
My Ride: 1098S; RR Sport; CRZ
Any excel geniuses still around?

Looking for a multiple "If" function formula that will take into account a number of cells.

Entire scenario verbally:

If C11>0, then (C11/D11)-1

If C11 and L11 both > 0, then (c11+L11)/(d11+m11)-1

If C11,L11,C26 all > 0, then (c11+L11+c26)/(d11+m11+d26)-1

If C11,L11,C26,L26 all > 0, then (C11+L11+C26+L26)/(D11+M11+D26+M26)-1
__________________

Santa Hats thanks to Scott!
Click for pics of my bikes
Click for pics of my old 335
Click for pics of my old S4 avant
Click for pics of my old M3


Quote:
Originally Posted by v8 5 View Post
Constatine would of thrown his dildo at the kidnapper and proceed to cry in his closet after said kidnapper escaped.
MpoweredM is offline   Reply With Quote
Old 04-18-2017, 08:39 AM   #2
Zell
Registered User
 
Zell's Avatar
 
Join Date: Jun 2009
Location: such united many state
Posts: 5,895
My Ride: so turbo wow
Step 1: Download R
Step 2: Delete Excel permanently

Sent from your mom's bedroom during pillow talk
__________________
Zell is offline   Reply With Quote
Old 04-18-2017, 08:44 AM   #3
trizzuth
Registered User
 
Join Date: May 2005
Location: MA$$HOLE
Posts: 6,032
My Ride: 231k, 16yr old B3AST
Sounds like you need a combo of IF, THEN, ELSE statements in there.

Just change the names at the beginning of each quarter, enter the new grades at the end of each quarter, and Excel calculates the results. A. Enter this formula in cell C4: =IF(B4<70,"FAIL","PASS***8221 . This means if the score in B4 is less than 70, then enter the word FAIL in cell B4, else/otherwise enter the word PASS.Mar 10, 2017
__________________
trizzuth is offline   Reply With Quote
Old 04-18-2017, 09:00 AM   #4
cowmoo32
.--. . -. .. ...
 
cowmoo32's Avatar
 
Join Date: Jul 2003
Location: FL
Posts: 5,545
My Ride: Yukon
Split them up.
Code:
 IF(A>B) AND (B>C) THEN ....
https://exceljet.net/formula/if-this-and-that

Also, Python > Excel
__________________

Last edited by cowmoo32; 04-18-2017 at 09:01 AM.
cowmoo32 is offline   Reply With Quote
Old 04-18-2017, 09:12 AM   #5
SamDoe1
Registered User
 
Join Date: Oct 2010
Location: Minnesnowta
Posts: 3,667
My Ride: 4cyl of fury
I just use multiple cells to make that sort of a calculation. I'm an Excel newb.
SamDoe1 is offline   Reply With Quote
Old 04-18-2017, 09:48 AM   #6
MpoweredM
Wants to be Orange
 
MpoweredM's Avatar
 
Join Date: Sep 2004
Location: Washington DC
Posts: 13,307
My Ride: 1098S; RR Sport; CRZ
I wish I didn't need to use excel. Unfortunately it's work based through google docs.

If then is a pain in the ass to understand with this. ***55357;***56834;

Last edited by MpoweredM; 04-18-2017 at 09:59 AM.
MpoweredM is offline   Reply With Quote
Old 04-19-2017, 01:38 AM   #7
Cowspoo
Registered User
 
Join Date: Aug 2008
Location: Chicago
Posts: 849
My Ride: 328Ci
This sheet sounds like a mess, here's the formula as one

Quote:
=if(and(c11>0,l11>0,C26>0,L26>0),(C11+L11+C26+L26)/(D11+M11+D26+M26)-1,if(and(C11>0,L11>0,C26>0),(c11+L11+c26)/(d11+m11+d26)-1,if(and(c11>0,l11>0),(c11+L11)/(d11+m11)-1,if(c11>0,(C11/D11)-1,"None are greater than zero"))
__________________
spacebarissolazy
doesntfeelikebeingpressed
Cowspoo is offline   Reply With Quote
Old 04-22-2017, 06:46 PM   #8
MpoweredM
Wants to be Orange
 
MpoweredM's Avatar
 
Join Date: Sep 2004
Location: Washington DC
Posts: 13,307
My Ride: 1098S; RR Sport; CRZ
Lets give this a whirl.

the sheet itself is pretty simple. Just want an "easier" way to recognize period to date growth. where each period contains 4 weeks of sales.
__________________

Santa Hats thanks to Scott!
Click for pics of my bikes
Click for pics of my old 335
Click for pics of my old S4 avant
Click for pics of my old M3


Quote:
Originally Posted by v8 5 View Post
Constatine would of thrown his dildo at the kidnapper and proceed to cry in his closet after said kidnapper escaped.
MpoweredM is offline   Reply With Quote
Old 04-22-2017, 06:49 PM   #9
MpoweredM
Wants to be Orange
 
MpoweredM's Avatar
 
Join Date: Sep 2004
Location: Washington DC
Posts: 13,307
My Ride: 1098S; RR Sport; CRZ
Damn snap. It works. Was missing two parentheses, but works now! Thanks man.
__________________

Santa Hats thanks to Scott!
Click for pics of my bikes
Click for pics of my old 335
Click for pics of my old S4 avant
Click for pics of my old M3


Quote:
Originally Posted by v8 5 View Post
Constatine would of thrown his dildo at the kidnapper and proceed to cry in his closet after said kidnapper escaped.
MpoweredM is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

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 On
Censor is ON





All times are GMT -5. The time now is 09:39 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
(c) 1999 - 2016 performanceIX Inc - privacy policy - terms of use