+ Reply to Thread
Results 1 to 3 of 3

Advice & Answer for Multiple IF Statement

  1. #1
    Registered User
    Join Date
    01-25-2013
    Location
    Taunton, England
    MS-Off Ver
    Excel 2003 Office, Excel 2010 Home
    Posts
    13

    Advice & Answer for Multiple IF Statement

    Hi All,

    I would like advice and help with a Multiple IF question as complete novice with Formulae and have read so much on IF, AND, OR am getting confused.

    What I would like help on is the following:

    There is a Date in Cell A1.
    Cell B1 would show the following "text" based on the condition below:
    1. If the Date is between 0-91 days from the date in A1, show "0-13 Weeks"
    2. If the Date is between 92-140 days from the date in A1 show "14-20 Weeks"
    3. If the Date is between 141-210 days from the date in A1 show "21-30Weeks"

    There are 2 additional conditions but I will add (and learn) them later.

    Can anyone help with the above.

    Many Thanks

    Craig

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Advice & Answer for Multiple IF Statement

    hi craig,

    you did not say where is this other date that you need to deduct from the date in A1. i will assume that it is in A2 and it is greater than that in A1.

    place this in B1:

    Please Login or Register  to view this content.
    UPDATE:

    if you would like to use TODAY(), it is certainly a good idea, however, not directly in the formula. TODAY() is considered a "volatile" function and hence induces some performance impedance in whichever cell it is called into. what i would recommend is, put =TODAY() in cell A2 and use the formula that i have provided above, which indirectly calls that value - this way, only one cell in the workbook is marked "volatile", and not all the cells containing the above formula. i hope i was able to explain that well.
    Last edited by icestationzbra; 03-27-2013 at 05:50 PM.
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  3. #3
    Registered User
    Join Date
    01-25-2013
    Location
    Taunton, England
    MS-Off Ver
    Excel 2003 Office, Excel 2010 Home
    Posts
    13

    Re: Advice & Answer for Multiple IF Statement

    Hi icestationzbra.

    Thanks for the reply....didn't even consider a Lookup as never used that VLook and HLook but not that excellent.

    I hadn't thought of a date deduction but have input your formula into my test sheet and works great.

    What I think is best for the 'Deduction Date' is =TODAY() as unless you say different this will allow the formula to change as each day passes i.e updating as we go along - I hope I am right in my theory there and please tell me if not.

    Would welcome your comment on the above.

    Craig

+ Reply to Thread

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