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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. sfinx59

    Display link_location instead of friendly name

    sfinx59, Mar 22, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    202
    Guest
    Mar 22, 2005
  2. K

    HYPERLINK friendly name problem

    K, Nov 16, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    327
  3. 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:
    142
    Guest
    Jan 31, 2007
  4. ExcelUser

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

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

    Array-friendly functions

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

Share This Page