Results 1 to 28 of 28

Nested IF Functions

Threaded View

stephen1000 Nested IF Functions 12-10-2008, 05:46 PM
mewingkitty My convoluted system 12-10-2008, 05:59 PM
JBeaucaire You can nest 7 if statements... 12-10-2008, 06:01 PM
stephen1000 Hi E2 is the entry point,... 12-10-2008, 06:18 PM
JBeaucaire Please download and review... 12-10-2008, 06:46 PM
stephen1000 I have, but it does not... 12-10-2008, 07:00 PM
stephen1000 N7 should read 1 n8 should... 12-10-2008, 07:06 PM
JBeaucaire I created a LOOKUP designed... 12-10-2008, 07:22 PM
JBeaucaire OK, I realized your cell D5... 12-10-2008, 07:49 PM
stephen1000 Thanks JB I get it, but not... 12-11-2008, 11:22 AM
JBeaucaire Be sure to EDIT your original... 12-11-2008, 12:43 PM
stephen1000 Hi JB help if you can or want... 12-15-2008, 07:41 PM
JBeaucaire Did you just ask a question I... 12-15-2008, 08:26 PM
stephen1000 Hi JB, I thought it was, I... 12-16-2008, 12:10 PM
JBeaucaire How many more? Any chance you... 12-16-2008, 12:42 PM
stephen1000 Hi Jb thanks will do. ... 12-16-2008, 03:45 PM
stephen1000 Hi JB attached is the... 12-16-2008, 04:07 PM
JBeaucaire Here you go. I made the... 12-16-2008, 04:24 PM
stephen1000 Hi JB Thanks for that, ... 12-16-2008, 04:51 PM
JBeaucaire It was really bugging me... 12-16-2008, 05:39 PM
stephen1000 Hi JB Thats awesome man, ... 12-16-2008, 06:21 PM
stephen1000 Hey JB Fixed it, too much... 12-16-2008, 06:23 PM
stephen1000 BL*********dy pc crashed ... 12-16-2008, 06:35 PM
JBeaucaire I noticed you had triggered... 12-16-2008, 06:48 PM
stephen1000 Hi JB, I was out all day... 12-17-2008, 04:16 PM
JBeaucaire Well, built into LOOKUP is... 12-17-2008, 04:51 PM
stephen1000 Hi JB checking now looks... 12-17-2008, 05:02 PM
stephen1000 :) Hi JB I have checked... 12-17-2008, 05:44 PM
  1. #2
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    My convoluted system

    I see some if functions here and there, but without knowing which ones you want to have precedence I can't really put them together for you.

    Anytime I need to put together a large group of "if"s, I do them one at a time, a-like-a-so
    enter your first step into a cell
    =if(a2>2,"Greater than 2","next step"
    in the cell under it, the next step
    =if(a2=2,"Equals 2","next step"
    and so on and so forth
    =if(a2<2,"Less than 2","End code"
    That way you can test each section while still only changing your initial data, also works if they're dependant upon eachother ( The code would simply refer to the cell above it for it's criteria ). When you want to conglomerate them all, start at the bottom, (I'd recommend making a copy of them while seperated for future use), anyways, start at the bottom, and work your way up, replacing "Next step" with the formula from the line below it, without the = of course ( If the cells are dependant upon eachother, you'd replace any part of the code which had say.. A2, with the formula in A2) . Add one more bracket on the end for each IF you add, and there you have it - An insanely complex if statement which is completely indicipherable. But functional.

    p.s.
    I'd REALLY recommend keeping a copy of the broken down versions for future use, saves a lot of trouble if criteria changes.
    Last edited by mewingkitty; 12-10-2008 at 06:02 PM. Reason: Cuz I luvz editz!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1