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

Thread: looking for excel formula.

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Im using microsoft office 97, excell and have ran into a simple mind math problem, that has giving me a mind melt down looking for the formula to get excel to do the same thing.
    Im trying to get one cell to break down into three cells with a FIXED VALUE RANGE.
    AS in:
    A1= 15.0 INTO,
    C1= 0.1 THROUGH 8.0
    D1= 8.1 " 12.0
    E1=12.1 " THE BALANCE OF A1.
    EXAMPLES:
    A1 = 15.0, A1 = 9.5, A1 = 7.5

    C1 = 8.0, C1 = 8.0, C1 = 0.0 (OR BLANK)
    D1 = 4.0, D1 = 1.5, D1 = 0.0
    E1 = 3.0, E1 = 0.0, E1 = 0.0

    I need a formula that will make this work for me or a 5lb slug hammer emailed to me for some computer violence. I and my computer will be greatfull for any help. Bob,

    [ This Message was edited by: cblincoln43 on 2002-03-13 09:05 ]

    [ This Message was edited by: cblincoln43 on 2002-03-13 09:09 ]

    [ This Message was edited by: cblincoln43 on 2002-03-13 09:11 ]

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Birmingham, Al
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It is a brain teaser, but try this:

    in B1 use this formula:

    =if(A1="","",if(A1>8,8,A1))

    in C1 use this formula:

    =if(A1="","",if(A1>12,12,A1-8))

    and last, in D1 use this formula:

    =if(A1="","",if(A1>12,A1-12,0))

    Was this close? I haven't tried it...
    neo

    [ This Message was edited by: neo on 2002-03-13 09:12 ]

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    THANK YOU FOR THE WELCOME & THE SHOT TO TRY WILL HAVE TO TRY IT TOMORROW, WILL POST IF IT WORKS. I NEVER DREAMED I WOULD RECIEVE A RESPONCE BEFORE I EVEN FINISHED EDITING. THANK YOU. Bob.

  4. 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
    •