1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Need help with Excel Formula

Discussion in 'Business Applications' started by reporter1, Feb 25, 2009.

Thread Status:
Not open for further replies.
Advertisement
  1. reporter1

    reporter1 Thread Starter

    Joined:
    Mar 6, 2008
    Messages:
    43
    This is a tough formula and I and having alot of problems figuring this out and wondering if any one can assist with this.

    I need to format an excel doc giving priority to the column marked DMR, meaning if a number is in the negative in the DMR column I have to back fill the negative number from the IMR column to bring the DMR column to a number of 0, if DMR and IMR are both negative then I can pull from the DDD column to bring the DMR column to a zero. Any number coming from IMR or DDD will then be less the number added to the DMR column.
    Also each row of numbers is a half hr period and has to be able to be ran for a day a week or even a month if that is any help but it will always be in this order but the numbers will chng for each day period.
    Thank you for any help you can be.




    DDD GSL PRD OCS DMR GSS PSS IMR
    5 -83 -3 6 -8 3 12
    4 -66 4 3 -14 -4 17
    4 -45 -2 -8 1 -1 8
    6 -31 -1 -5 5 -2 7
    -1 -28 -5 -5 2 -1 3
    1 -16 -3 -5 0 -5 2
    1 -25 0 -4 -1 -2 -1
    0 -21 2 -5 7 -3 1
    -1 -23 2 -5 6 -2 1
    -2 -14 4 -5 4 -2 1
    -2 -16 5 -9 9 -2 2
    1 -14 3 -6 12 -8 8
    4 -17 3 -7 13 6 9
    7 -22 3 -10 10 7 11
    6 -32 4 -4 13 9 18
    16 -41 3 0 17 16 19
    14 -61 2 3 7 29 17 17
    16 -76 3 5 7 42 28 15
    11 -85 -1 0 2 43 32 21
    25 -140 -3 -3 2 41 32 26
    26 -156 -6 4 6 44 35 27
    24 -190 -6 -5 7 62 47 28
    28 -200 -9 -7 14 68 47 25
    25 -200 -9 -14 14 64 36 28
    16 -156 -15 -13 15 67 48 30
    26 -150 -11 -12 18 74 34 33
    25 -173 -6 -7 19 67 38 28
    32 -172 -6 -14 18 99 44 36
    28 -179 -11 -16 23 108 40 34
    28 -155 -10 -14 27 106 49 33
    39 -165 -5 -13 35 113 42 33
    37 -168 8 -20 38 99 43 17
    35 -159 5 -19 34 107 50 20
    32 -156 -7 -3 26 104 33 23
    29 -147 -4 -1 30 85 30 22
    26 -159 -4 0 31 88 28 14
    21 -152 -6 -13 26 83 31 13
    18 -133 -3 -18 24 71 29 14
    20 -130 -3 -17 20 59 18 15
    15 -135 -15 -17 17 62 16 13
    9 -149 -9 -19 20 59 15 15
    10 -178 -9 -32 16 50 15 10
    7 -165 -9 -24 22 49 11 8
    8 -168 -12 -33 14 40 10 11
    11 -152 -6 -29 16 37 10 17
    15 -140 -6 -29 15 21 12 14
    11 -122 0 -30 16 24 10 8
    8 -78 4 -18 15 3 8 8
    4 -74 -5 9 17 4 10
    5 -50 0 8 7 3 13
    5 -40 -2 -6 11 0 14
    13 -20 -8 -4 13 -1 14
    8 -15 -6 -4 4 -3 7
    8 -10 -2 -3 7 -3 9
    8 -6 -2 -3 10 -2 7
    7 -7 0 -3 11 -1 6
    5 -4 3 -3 14 -4 7
    6 -1 1 -3 10 3 7
    5 4 4 -3 12 1 10
    3 6 0 -3 13 -1 7
    6 2 1 -3 17 7 9
    6 -5 3 -4 17 4 9
    5 -19 3 2 22 8 16
    12 -32 3 2 22 14 18
    12 -53 1 0 6 37 15 18
    14 -76 -2 -1 9 48 19 15
    11 -79 -3 -4 12 61 22 19
    18 -131 -4 -1 17 67 21 23
    18 -144 -7 6 19 73 21 26
    23 -181 -6 -8 21 82 30 27
    24 -205 -11 -3 26 82 47 25
    20 -209 -12 -14 19 91 30 23
    13 -181 -12 -14 26 85 26 34
    23 -177 -10 -5 25 94 19 34
    17 -193 -9 -11 26 74 27 26
    28 -198 -7 -13 13 98 33 30
    24 -214 -16 -12 24 83 28 33
    21 -209 -13 -10 28 82 20 31
    40 -210 -11 -24 31 91 21 27
    36 -215 1 -24 25 92 14 13
    30 -216 0 -18 24 100 21 10
    28 -185 2 -14 21 80 15 13
    21 -169 -6 -14 24 76 13 13
    33 -175 -6 -10 26 84 20 11
    30 -154 -4 -15 15 77 21 16
    28 -159 -4 -18 17 76 18 15
    32 -131 2 -15 16 63 15 16
    25 -136 -8 -9 14 55 16 15
    17 -127 -3 -10 11 59 15 17
    25 -154 -3 -14 9 60 20 15
    20 -139 -4 -7 13 54 9 14
    16 -145 -6 -10 9 42 -1 10
    16 -141 -2 -19 9 30 6 14
    19 -129 2 -20 3 17 4 10
     
  2. reporter1

    reporter1 Thread Starter

    Joined:
    Mar 6, 2008
    Messages:
    43
    The example pasted doc did not come thru as intended sorry
     
  3. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Can you attach a file (replace sensitive data with dummy data)?
     
  4. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    I just put the above in a file Cman
     

    Attached Files:

    • test.xls
      File size:
      19.5 KB
      Views:
      157
  5. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    By looking at the File Slurpee attached, what happens if the DMR number is negative and there is nothing in the IMR?

    Assuming the numbers must be pulled from the same row.
     
  6. reporter1

    reporter1 Thread Starter

    Joined:
    Mar 6, 2008
    Messages:
    43
    Just walked back, sorry thatnk you for attchng the file but the IMR column always has a negative or a positive number.
     
  7. reporter1

    reporter1 Thread Starter

    Joined:
    Mar 6, 2008
    Messages:
    43
    The PRD column sometimes has nothing in it representing zero but that would not be in this formula
     
  8. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    given your note that there should always be something in the last column.
    And I haven't verified the numbers really...just some ideas.
     

    Attached Files:

  9. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/804220

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice