+ Reply to Thread
Results 1 to 4 of 4

Can't figure out how to input this IF function with structured references

  1. #1
    Registered User
    Join Date
    04-28-2017
    Location
    Alabama
    MS-Off Ver
    Microsoft Excel
    Posts
    12

    Unhappy Can't figure out how to input this IF function with structured references

    I’ve been struggling to figure out how to type in this IF function for excel. I could really use some help! Thank you!!

    On the Imaging Staff worksheet in cell G2, create a formula using the IF function and structured references to create a calculated column that determines the value of Weeks Vacation based on the following criteria:

    a. If the years employed are less than 3, the Weeks Vacation should be 2

    b. If the years employed are 3 or more, the Weeks Vacation should be 3

    I keep getting invalid credentials or the outcomes being all FALSE, TRUE and 0, all the cells being 0, or the first 3 cells being 0 and the last 3 coming out as NULL instead of the correct numbers… The correct answers when the formula is entered correctly is:
    G2:3
    G3:2
    G4:3
    G5:2
    G6:3
    G7:3

    I attached the excel file if that helps. Thanks again!
    Attached Files Attached Files

  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,147

    Re: Can't figure out how to input this IF function with structured references

    in G2

    =IF([@[Years Employed]]<3,2,3)

    copy down

  3. #3
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Can't figure out how to input this IF function with structured references

    Give this a try =IF([@[Years Employed]]<3,Value if True, Value if False)

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  4. #4
    Registered User
    Join Date
    04-28-2017
    Location
    Alabama
    MS-Off Ver
    Microsoft Excel
    Posts
    12

    Re: Can't figure out how to input this IF function with structured references

    Oh my gosh! Thank you so much!!!!

+ 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] Cannot use structured references for tables
    By aliceinwonderland in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2018, 01:29 PM
  2. Structured references
    By tim201110 in forum Excel General
    Replies: 1
    Last Post: 02-19-2017, 07:48 PM
  3. Trouble with Structured References
    By xanthum in forum Excel General
    Replies: 7
    Last Post: 01-04-2017, 07:49 PM
  4. Using Structured Table References and Indirect Function
    By tjeasy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-02-2016, 07:07 PM
  5. [SOLVED] Issue with nested IF function and structured references
    By jason1983 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-28-2015, 08:13 PM
  6. VBA / Structured Table References
    By carlyman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-08-2014, 06:11 AM
  7. Help with structured references
    By hellur_kitty in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-07-2013, 10:50 PM

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