+ Reply to Thread
Results 1 to 1 of 1

IF function nested

  1. #1
    Registered User
    Join Date
    09-04-2019
    Location
    Saudi Arabia
    MS-Off Ver
    365
    Posts
    17

    IF function nested

    I am creating a timesheet to enter the total hrs.work. Just having issues on the Thursday row where maximum hrs to charge the client is hours.
    I want to use the IF Function to enter a value in one cell and ave 2 cells which has 3 criteria each.

    Given hours of staff every thursday:
    Week 1 - total office hours worked is 10. (return value should be 8hrs)
    Week 2 - total offsite hours worked is 10. (return value should be 8 hrs)
    Week 3 - total office hours worked is 6 (return value should be 6 hrs)
    Week 4 - total offsite hours work is 7.(return value should be 7 hrs)

    I would greatly appreciate your help thanks.
    Attached Files Attached Files
    Last edited by Ces1013; 09-04-2019 at 03:07 PM.

+ 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. Replies: 2
    Last Post: 01-05-2019, 03:33 AM
  2. [SOLVED] Nested vlookup or nested IFAND function?
    By jeptik in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2017, 02:27 AM
  3. 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
  4. COUNTIF/COUNTIFS function + nested user-defined function
    By shamjamali in forum Excel General
    Replies: 1
    Last Post: 05-12-2015, 09:12 PM
  5. [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
  6. [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
  7. [SOLVED] 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