+ Reply to Thread
Results 1 to 9 of 9

Adding more variables to my IF formula

Hybrid View

  1. #1
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.97.2 for Mac MS 365
    Posts
    8,711

    Re: Adding more variables to my IF formula

    The only option I can think of is if M2 is equal to K2 where On Time might be the option.
    So maybe this... =IF(M2="","",IF(M2=K2,"On Time",IF(M2>K2, "Late", "Early")))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  2. #2
    Registered User
    Join Date
    01-07-2021
    Location
    Perth, Australia
    MS-Off Ver
    2016
    Posts
    11

    Re: Adding more variables to my IF formula

    Yes!! This is working beautifully. Perfect, just what I was after. 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. Replies: 1
    Last Post: 07-29-2020, 09:51 AM
  2. [SOLVED] adding two time variables to an existing formula
    By chriswrcg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2019, 08:01 AM
  3. [SOLVED] Adding Different Variables
    By Excel-Access in forum Excel General
    Replies: 2
    Last Post: 03-22-2019, 06:11 PM
  4. [SOLVED] adding extra variables
    By andyrocks256 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2015, 03:49 PM
  5. Help with adding columns with variables
    By NickTank in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2012, 09:51 PM
  6. Adding variables
    By cj21 in forum Excel General
    Replies: 1
    Last Post: 09-29-2011, 06:19 AM
  7. adding value variables to name ranges
    By dagindi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-01-2010, 06:07 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