Results 1 to 3 of 3

What function to use to display a # value if under or over a specific number?

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2013
    Location
    Georgia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question What function to use to display a # value if under or over a specific number?

    HELP!

    Calculating time cards I need a function to display the value if the time is before 8.00 and another function to display the value if the time is over 16.50

    So if the time is 7.71, I need a function to display that the time is 0.29
    Or if the time is 17.76, I need a function to display that the time is 1.26
    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. Replies: 4
    Last Post: 04-21-2013, 01:09 PM
  2. Display only numbers with a specific number
    By floydstyle in forum Excel General
    Replies: 2
    Last Post: 02-21-2013, 06:41 AM
  3. [SOLVED] Condition and function to write number value greater than a specific number
    By excelinexcel7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2012, 06:09 PM
  4. Search & display a specific format in a number of columns using lookup
    By sarahhllmn in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-15-2011, 06:48 AM
  5. Linking IF statements to display specific number
    By LKM Kevin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-26-2010, 04:19 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