+ Reply to Thread
Results 1 to 3 of 3

Double IF Statements - Help!

  1. #1
    Registered User
    Join Date
    09-06-2019
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    2

    Double IF Statements - Help!

    Hi guys, I'm new here - nice to meet you all!

    I am having a bit of trouble with combining some Excel IF statements...

    I am working with week numbers in a financial year (1-52), so and am working out the number of weeks stock has been selling in a shop.

    e.g. A line came in during week 42, so it's first 12 weeks selling would be week 42 to week 1. In my first column I have the week number (42) + 12 to take you to 54.

    So the first part of my IF needs to be IF the week number + 12 is greater than 52, then -53, if not then keep the original value
    For this, I've used: =IF(B5>52,B5-53,B5)

    Then I also have a second one, IF the week number + 12 = 53, then the result needs to be 52, if not then keep the original value
    For this, I've used: =IF(B5=53,"52",B5)

    I can't seem to put the 2 IF's together, so that it does one or the other?

    Hopefully it's an easy fix, but if anyone can help I'd really appreciate it! Thanks in advance!
    Last edited by heatherdinho; 09-06-2019 at 06:55 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    25,903

    Re: Double IF Statements - Help!

    Hi and welcome to the forum.

    When nesting IFs, the third FALSE element of one IF statement needs to be the second IF statement.

    Maybe
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    However upload the workbook and explain how you use it and add some results and no doubt we can help further - perhaps even simplify things.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    09-06-2019
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Double IF Statements - Help!

    Hi Richard,

    Thank you for the speedy reply! That's amazing, it worked :D

    Thanks so much for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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