# Need help with Excel Formula

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

Not open for further replies.

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.

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

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

3. ### computerman29642

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

4. ### slurpee55

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

File size:
19.5 KB
Views:
157
5. ### 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.

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.

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

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.

File size:
45.5 KB
Views:
149

As Seen On