looking for excel formula.
looking for excel formula.
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. 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
    •