+ Reply to Thread
Results 1 to 2 of 2

Nested IF Function with 3 Variables... Help!

  1. #1
    Registered User
    Join Date
    08-06-2017
    Location
    United States
    MS-Off Ver
    Office 2016
    Posts
    1

    Exclamation Nested IF Function with 3 Variables... Help!

    I've created a spreadsheet to keep track of my time (clock in/clock out). I have my IF function working for all of my clocks except the days where I have three clocks.

    For example... I have days where I clock in/out and then work from home and have another clock time as well. It's those days that are tripping me up.

    For my regular two day times:
    =IF((K6+L6)>0,(K6+L6),(E6-D6))

    I just can't get that third variable working. I've tried to nest it but apparently this is smarter than me. I'm on a time crunch to get this working, too.

    If anyone has any ideas or help they can throw my way, I'd be super grateful!

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Nested IF Function with 3 Variables... Help!

    Hi abahr, welcome to Excel Forum! A small sample workbook (NOT a picture) would really help us to solve your problem quickly and accurately.
    Remove any sensitive or extraneous info, just give us some data to test and some simulated results to demonstrate what you want.
    (Be sure the data is “realistic”, w examples of any variations the code or formula must address.)

    To attach a workbook:
    Click Edit Post (or just start a new reply.)
    Click Go Advanced
    Scroll down to Manage Attachments and click.
    Now just Browse for your file, then click Upload. Simple!
    Last edited by leelnich; 08-07-2017 at 01:37 AM.

+ 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. Nested if statement with three variables
    By kisboros in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-27-2013, 03:13 PM
  2. Nested VLOOKUP & SUMIF in IF STATEMENT with several variables
    By sarahw in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2013, 02:47 PM
  3. Nested For Each loop for 2 range variables
    By artur.serra in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 10:34 AM
  4. Nested IF Formula Using Variables
    By Gard5096 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-08-2013, 02:36 PM
  5. Replies: 3
    Last Post: 09-11-2012, 02:03 AM
  6. How do I set up a nested SUMIF formula for a number of variables?
    By Nancy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2006, 02:10 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