+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 Nested IF Formula

  1. #1
    Registered User
    Join Date
    06-01-2016
    Location
    caribbean
    MS-Off Ver
    2007
    Posts
    1

    Lightbulb Excel 2007 Nested IF Formula

    Hello All,
    I am trying to get a formula in which the results are all dates plus a certain number of days. I am getting an error while trying to add the days. This is the formula

    =IF(R3=CECs!,"10+CECs!F3",IF(CECs!R3=CECs!B4,"30+CECs!F3",IF(CECs!R3=CECs!B5,"30+CECs!F3",IF(R3=CECs!B6,"30+CECs!F3",IF(R3=CECs!B7,"30+CECs!F3",IF(R3=CECs!B8,"30+CECs!F3",IF(R3=CECs!B9,"21+CECs!F3",IF(R3=CECs!B10,"AWAITING",IF(R3=CECs!B11,"10+CECs!F3",IF(R3=CECs!B12,"AWAITING",IF(R3=CECs!B13,"80+CECs!F3")))))))))))

    If the cell has a value that is equal to a cell in another spreadsheet in the same workbook then it will add a certain number of days to a cell with a date. The bold section is where I am starting to get the error. Here I am trying to add 10 days to a date which is in the cell CECs!F3. Most of the other returns are a certain number of days added to a date value in a specific cell. So again the main problem is how do I add a number of days to a fixed date. I am using Excel 2007 btw. If anyone can help me that would be great I've been trying to figure this out for a week now

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: Excel 2007 Nested IF Formula

    Try

    =IF(R3=CECs!xx,10+CECs!F3,IF(CECs!R3=CECs!B4,30+CECs!F3,IF(CECs!R3=CECs!B5,30+CECs!F3,IF(R3=CECs!B6,30+CECs!F3,IF(R3=CECs!B7,30+CECs!F3,IF(R3=CECs!B8,30+CECs!F3,IF(R3=CECs!B9,21+CECs!F3,IF(R3=CECs!B10,"AWAITING",IF(R3=CECs!B11,10+CECs!F3,IF(R3=CECs!B12,"AWAITING",IF(R3=CECs!B13,80+CECs!F3)))))))))))

    You need to remove the quotes round your addition of days.

    Plus error where xx is in formula

+ 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] Need to convert formula to Excel 2007 format for nested IFS
    By hmr2662 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-12-2015, 08:36 AM
  2. [SOLVED] Excel 2007 : nested if more than 5
    By chrismonica in forum Excel General
    Replies: 4
    Last Post: 02-28-2012, 03:37 PM
  3. EXCEL 2007; Nested IF Formulas - NEED HELP!
    By rodneyk in forum Excel General
    Replies: 6
    Last Post: 12-08-2011, 05:02 PM
  4. Excel 2007 Nested IF Functions, please help!
    By Zulli85 in forum Excel General
    Replies: 4
    Last Post: 03-07-2011, 05:08 AM
  5. Nested IF statements with Text as IF and THEN (Excel 2007)
    By mrsbigglesworth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2010, 09:02 AM
  6. Nested IF statements with Text as IF and THEN (Excel 2007)
    By mrsbigglesworth in forum Excel General
    Replies: 2
    Last Post: 12-13-2010, 01:48 AM
  7. [SOLVED] Excel 2007 : Nested Vlookup formula
    By merlin704 in forum Excel General
    Replies: 2
    Last Post: 10-17-2008, 04:48 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