+ 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
    26,704

    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)

Similar Threads

  1. [SOLVED] if statement - usage of double if statements - solved
    By lydte in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-22-2017, 01:53 AM
  2. Double click cell - copy data to new sheet - create a list from double clicking
    By kakky in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-04-2015, 11:14 PM
  3. [SOLVED] Before double click event with if statements (Double clicking blank cell stops bdc firing)
    By camdenpars in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-27-2014, 09:03 AM
  4. [SOLVED] Double click event with multiple if statements
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-24-2014, 01:20 AM
  5. Copy double-clicked cell to next empty row in different sheet with each double-click
    By erhathaway in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-25-2013, 12:06 AM
  6. Double stack and double line graph
    By Karen311261 in forum Excel General
    Replies: 5
    Last Post: 10-06-2010, 11:58 AM
  7. Double IF Statements
    By samtwilliams in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2007, 04:59 PM

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