Re: Formula not being Friendly

Discussion in 'Microsoft Excel Worksheet Functions' started by Living the Dream, Aug 9, 2012.

  1. Hi

    Firstly

    You do not need to use the Value() in the time formula.
    It works just as well without.

    =IF(G2<H2,"Breached",G2-H2)

    Secondly

    Unless you have a 3rd logic eg Low, Medium & High ( of which you only
    use Low/Medium), you will only need to do this:

    =IF(C2="Medium",WORKDAY(E2,3)+E2-INT(E2),WORKDAY(E2,5)+E2-INT(E2))

    And Lastly

    In the format screen, select Custom and copy this in

    d "Days", hh:mm:ss

    It will display 5 Days, 10:20:20

    HTH
    Mick.
     
    Living the Dream, Aug 9, 2012
    #1
    1. Advertisements

  2. ok

    Rule 1. =I1="Breached"
    Rule 2. =I1<=0.375
    Rule 3. =IF(I1<=0.625,AND(I1>0.375))
    Rule 4. =IF(I1<=1.25,AND(I1>0.625))
    Rule 5. =I1>1.25

    HTH
    Mick.
     
    Living the Dream, Aug 13, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. jannster

    Formula being displayed as text after a change is made in the formula.

    jannster, Oct 8, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    362
    Frank Kabel
    Oct 8, 2004
  2. jannster

    Formula being displayed as text after a change is made in the formula.

    jannster, Oct 21, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    799
    JE McGimpsey
    Oct 21, 2004
  3. sfinx59

    Display link_location instead of friendly name

    sfinx59, Mar 22, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    273
    Guest
    Mar 22, 2005
  4. Guest

    CountIf formula results in the formula itself being displayed.

    Guest, Dec 21, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    9
    Views:
    2,750
    Gord Dibben
    Dec 21, 2005
  5. K

    HYPERLINK friendly name problem

    K, Nov 16, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    648
  6. Guest

    Drill to Details - is there user friendly way to delete the sheet

    Guest, Jan 31, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    191
    Guest
    Jan 31, 2007
  7. ExcelUser

    Hyperlink "friendly-name" won't preserve links in PDF publishing

    ExcelUser, Feb 2, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    489
    ExcelUser
    Feb 2, 2009
  8. vsoler

    Array-friendly functions

    vsoler, Sep 12, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    251
    Bernd P
    Sep 12, 2009
Loading...