### [Solved] IF then statements - requirements changed

Posted:

**Fri Feb 15, 2019 8:39 pm**Why do people always change requirements on you. Hopefully I do better and only need some direction like column M.

Maybe it would help if I list the columns so everyone can understand better what I am trying to do. In the parentheses I have listed the value that should be obtained by the formula. Rem marks are in [ ]. The first 4 columns are manually input.

Col C = Account (2848)

Col D = Purchase (274.18)

Col F = LG (28.01)

Col H = LGH (22.88)

Col J = New Total =sum(d3-f3-h3)

Col K = Always is 3

Col L = Per person (74.43) =j3/3

Col M = # Shares (1) =IF(OR(C3=1685;2;c3=3488;2;IF(C3=2848;1;""))

[If C3 = 2848 then M3=1

If C3 = 1686 then M3=2

If C3 = 3488 then M3=2]

Col N = LG Paid (74.43) =Sum(L3*M3)

Col O = LG Owe (102.44) =IF(OR(M3=1;=sum(F3,N3);IF(M3=;2;O3=leave field blank))

[If M3 = 1 then it equals F3 plus N3

If M2 = 2 then the field should be empty]

Col P = LGH Paid (148.86) =Sum(L3*M3)

Col Q = LGH Owe (blank) =IF(OR(M3=1;blank;IF(M3=2;=sum(H3+P3))

[If M3=1 then the field should be empty

If M3=2 then it equals H3 plus P3]

Wow. I hope this is close. I am definitely new to this.

Maybe it would help if I list the columns so everyone can understand better what I am trying to do. In the parentheses I have listed the value that should be obtained by the formula. Rem marks are in [ ]. The first 4 columns are manually input.

Col C = Account (2848)

Col D = Purchase (274.18)

Col F = LG (28.01)

Col H = LGH (22.88)

Col J = New Total =sum(d3-f3-h3)

Col K = Always is 3

Col L = Per person (74.43) =j3/3

Col M = # Shares (1) =IF(OR(C3=1685;2;c3=3488;2;IF(C3=2848;1;""))

[If C3 = 2848 then M3=1

If C3 = 1686 then M3=2

If C3 = 3488 then M3=2]

Col N = LG Paid (74.43) =Sum(L3*M3)

Col O = LG Owe (102.44) =IF(OR(M3=1;=sum(F3,N3);IF(M3=;2;O3=leave field blank))

[If M3 = 1 then it equals F3 plus N3

If M2 = 2 then the field should be empty]

Col P = LGH Paid (148.86) =Sum(L3*M3)

Col Q = LGH Owe (blank) =IF(OR(M3=1;blank;IF(M3=2;=sum(H3+P3))

[If M3=1 then the field should be empty

If M3=2 then it equals H3 plus P3]

Wow. I hope this is close. I am definitely new to this.