Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Shorten this formula, if it can be done

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Macon, Georgia USA
    Posts
    158
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anyone write a shorter formula, and can you also write me a formula using a lookup table for the formula below. This formula goes in 28 line.

    =IF(OR($A6=$F$2,$A6=$F$2+7),"Sun",
    IF(OR($A6=$F$2+1,$A6=$F$2+8),"Mon",
    IF(OR($A6=$F$2+2,$A6=$F$2+9),"Tue",
    IF(OR($A6=$F$2+3,$A6=$F$2+10),"Wed",
    IF(OR($A6=$F$2+4,$A6=$F$2+11),"Thu",
    IF(OR($A6=$F$2+5,$A6=$F$2+12),"Fri",
    IF(OR($A6=$F$2+6,$A6=$F$2+13),"Sat","")))))))

    Thank

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,006
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    What kind of data house A6 and F2: date, number, etc.? And, what is the purpose?

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Macon, Georgia USA
    Posts
    158
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    F2 is a date
    A6 is where my timesheet line begin

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Macon, Georgia USA
    Posts
    158
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    F2 is a date
    A6 is where my timesheet line begin
    and A33 is where it end

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Macon, Georgia USA
    Posts
    158
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Al,
    I will send you a copy of the sheets need to help me figure out what I am trying to accomplish.

    Thanks again,
    A long winded Aircraft Mechanic,
    Walter
    Never Stop Learning

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-20 05:08, TiggerToo wrote:
    Can anyone write a shorter formula, and can you also write me a formula using a lookup table for the formula below. This formula goes in 28 line.

    =IF(OR($A6=$F$2,$A6=$F$2+7),"Sun",
    IF(OR($A6=$F$2+1,$A6=$F$2+8),"Mon",
    IF(OR($A6=$F$2+2,$A6=$F$2+9),"Tue",
    IF(OR($A6=$F$2+3,$A6=$F$2+10),"Wed",
    IF(OR($A6=$F$2+4,$A6=$F$2+11),"Thu",
    IF(OR($A6=$F$2+5,$A6=$F$2+12),"Fri",
    IF(OR($A6=$F$2+6,$A6=$F$2+13),"Sat","")))))))

    Thank
    =CHOOSE(MOD($F$2-$A$2,7)+1,"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

  7. #7
    New Member
    Join Date
    Mar 2002
    Location
    Northern Ireland
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    =TEXT($F$2,"DDD")

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •