Excel Expert Needed - Techist - Tech Forum

 Techist - Tech Forum Excel Expert Needed

 03-22-2005, 02:19 PM #1 (permalink) Newb Techie   Join Date: Jul 2004 Posts: 8 Excel Expert Needed Hi, I'm working on a set of conditions in Excel that I just can't seem to get to work. Is there anyone out there who can claim to be an advanced user in Excel who can help me. It'd be greatly appreciated. Let me know and I'll send you the conditions I am trying to work. __________________ __________________
 03-22-2005, 04:08 PM #2 (permalink) It's all just 1s and 0s     Join Date: Jan 2004 Location: in the lab Posts: 6,555 post em, i like to think im proficient in excel. i shy away from pivot tables though. __________________ __________________ How To Move Win to New HD w/o Install CD/DVD Imagine the Possibilities and Make Them a Reality.™ ... Trust Your Instincts. <\*/>Best Windows Software - MakeUseOf.com<\*/> Geeks Are Sexy.net | ExtremeTech.com | Ars Technica.com | Slick Deals.Net | Code Project.com Tech Meme.com | HowTo Forge.com | Revision3.com | DevGuru.com | Rootsecure.net SQLServerCentral.com | Code Guru.com | SModcast.com | Lockergnome IT Pros
 03-22-2005, 04:42 PM #3 (permalink) Newb Techie   Join Date: Jul 2004 Posts: 8 IÂ’m trying to create a set of multi-conditions in Excel. See attached example (imagine it's a .xls). I need the formula to work thus: B2 = A1+6 C2 = A2-B2-15 IF C2 =(0-12) OR (-54 to -42), Using the same B2 value, I then want to know: When the next C#-B2-15 >12, <-54 So, after A(#)-B2-15 >12, <-54 [N.B. This part of the formula will use the same B2 value used to find when C2 =(0-12) OR (-54 to -42)] When C# does return >12, <-54, I then want the formula to end, and to restart by creating a new value in the B column, and then apply the above conditions. So, in the above table with A column values, C2=2. So, because itÂ’s between 0-12, I then want to know when A(#)-B2-15 > 12. In this case, C4=36. So then, I would want to get a new value in B5(10546) and take it from there. If, after C2=2, there were other values that were between 0-12 in the C column before a value of >12 or <-54(subsequent to value of -54 to -42), I would need them to be highlighted as well. It may be necessary to create two sets of columns: one for the 0-12, >12 range one for the -54 to -42, <-54 range Also, ideally, would it be possible to only let the values I am looking for appear and ignore the values that are not relevant. I hope that is clear. Thanks in advance. __________________

 Thread Tools Display Modes Linear Mode

 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 OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

#### Our Communities

Our communities encompass many different hobbies and interests, but each one is built on friendly, intelligent membership.

#### Marine Communities

Our Marine websites focus on Cruising and Sailing Vessels, including forums and the largest cruising Wiki project on the web today.

» More about our Marine Communities