Results 1 to 6 of 6

Nested IF's Function

Threaded View

BuckNut614 Nested IF's Function 12-05-2017, 04:07 PM
Pete_UK Re: Nested IF's Function 12-05-2017, 04:17 PM
BuckNut614 Re: Nested IF's Function 12-05-2017, 04:48 PM
Pete_UK Re: Nested IF's Function 12-05-2017, 04:56 PM
Syrkrasi Re: Nested IF's Function 12-05-2017, 05:20 PM
BuckNut614 Re: Nested IF's Function 12-06-2017, 12:58 PM
  1. #1
    Registered User
    Join Date
    12-05-2017
    Location
    Columbus
    MS-Off Ver
    2013
    Posts
    13

    Nested IF's Function

    In the Comp Days column, enter a formula with nested IFs to display the number of comp days that an employee will receive based on their years of service. The table for Comp Days is on the second worksheet. Remember to use absolute references to the cells in the second worksheet because the formula will be copied to the entire column.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Nested vlookup or nested IFAND function?
    By jeptik in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2017, 02:27 AM
  2. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  3. COUNTIF/COUNTIFS function + nested user-defined function
    By shamjamali in forum Excel General
    Replies: 1
    Last Post: 05-12-2015, 09:12 PM
  4. [SOLVED] Nested Function With Division - Receiving #VALUE! Function Error
    By DDM64 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-17-2013, 01:16 PM
  5. [SOLVED] Nested AND function within IF function is only addressing logical1 but not logical2
    By betic in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2012, 09:17 AM
  6. Replies: 9
    Last Post: 07-02-2012, 07:02 PM
  7. Offset function with nested match function not finding host ss.
    By MKunert in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2006, 06: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