Results 1 to 15 of 96
Thread: Logical Function with Vlookup

20100113, 14:15 #1
 Join Date
 Feb 2008
 Posts
 1,559
 Thanks
 139
 Thanked 12 Times in 12 Posts
I am looking for a logical formula to include with a lookup function to do the following
If the value in cell D18 is less than zero then cell D11 must be zero. If the value in cellD18 is greater than zero than cell D18 must be multiplied by 10%. However if cell D14 & D15 has a value and B18 is less than zero then the following table must be used below using a vlookup, using the cumulative value in col C i.e the 3rd column for F/end GP and 6 th col for B/end GP
[attachment=87708:Comms.xls]
However if B18 is greater than zero, then B18 must be multiplied by 10% plus following table must be used below, using the cumulative value in col C i.e the 3rd column
Your assistance will be most appreciated

20100113, 14:15 #2
 Join Date
 Feb 2008
 Posts
 1,559
 Thanks
 139
 Thanked 12 Times in 12 Posts
I am looking for a logical formula to include with a lookup function to do the following
If the value in cell D18 is less than zero then cell D11 must be zero. If the value in cellD18 is greater than zero than cell D18 must be multiplied by 10%. However if cell D14 & D15 has a value and B18 is less than zero then the following table must be used below using a vlookup, using the cumulative value in col C i.e the 3rd column for F/end GP and 6 th col for B/end GP
[attachment=87708:Comms.xls]
However if B18 is greater than zero, then B18 must be multiplied by 10% plus following table must be used below, using the cumulative value in col C i.e the 3rd column
Your assistance will be most appreciated

20100113, 14:15 #3
 Join Date
 Feb 2008
 Posts
 1,559
 Thanks
 139
 Thanked 12 Times in 12 Posts
I am looking for a logical formula to include with a lookup function to do the following
If the value in cell D18 is less than zero then cell D11 must be zero. If the value in cellD18 is greater than zero than cell D18 must be multiplied by 10%. However if cell D14 & D15 has a value and B18 is less than zero then the following table must be used below using a vlookup, using the cumulative value in col C i.e the 3rd column for F/end GP and 6 th col for B/end GP
[attachment=87708:Comms.xls]
However if B18 is greater than zero, then B18 must be multiplied by 10% plus following table must be used below, using the cumulative value in col C i.e the 3rd column
Your assistance will be most appreciated

20100113, 14:15 #4
 Join Date
 Feb 2008
 Posts
 1,559
 Thanks
 139
 Thanked 12 Times in 12 Posts
I am looking for a logical formula to include with a lookup function to do the following
If the value in cell D18 is less than zero then cell D11 must be zero. If the value in cellD18 is greater than zero than cell D18 must be multiplied by 10%. However if cell D14 & D15 has a value and B18 is less than zero then the following table must be used below using a vlookup, using the cumulative value in col C i.e the 3rd column for F/end GP and 6 th col for B/end GP
[attachment=87708:Comms.xls]
However if B18 is greater than zero, then B18 must be multiplied by 10% plus following table must be used below, using the cumulative value in col C i.e the 3rd column
Your assistance will be most appreciated

20100113, 14:15 #5
 Join Date
 Feb 2008
 Posts
 1,559
 Thanks
 139
 Thanked 12 Times in 12 Posts
I am looking for a logical formula to include with a lookup function to do the following
If the value in cell D18 is less than zero then cell D11 must be zero. If the value in cellD18 is greater than zero than cell D18 must be multiplied by 10%. However if cell D14 & D15 has a value and B18 is less than zero then the following table must be used below using a vlookup, using the cumulative value in col C i.e the 3rd column for F/end GP and 6 th col for B/end GP
[attachment=87708:Comms.xls]
However if B18 is greater than zero, then B18 must be multiplied by 10% plus following table must be used below, using the cumulative value in col C i.e the 3rd column
Your assistance will be most appreciated

20100113, 14:15 #6
 Join Date
 Feb 2008
 Posts
 1,559
 Thanks
 139
 Thanked 12 Times in 12 Posts
I am looking for a logical formula to include with a lookup function to do the following
If the value in cell D18 is less than zero then cell D11 must be zero. If the value in cellD18 is greater than zero than cell D18 must be multiplied by 10%. However if cell D14 & D15 has a value and B18 is less than zero then the following table must be used below using a vlookup, using the cumulative value in col C i.e the 3rd column for F/end GP and 6 th col for B/end GP
[attachment=87708:Comms.xls]
However if B18 is greater than zero, then B18 must be multiplied by 10% plus following table must be used below, using the cumulative value in col C i.e the 3rd column
Your assistance will be most appreciated

20100113, 14:15 #7
 Join Date
 Feb 2008
 Posts
 1,559
 Thanks
 139
 Thanked 12 Times in 12 Posts
I am looking for a logical formula to include with a lookup function to do the following
If the value in cell D18 is less than zero then cell D11 must be zero. If the value in cellD18 is greater than zero than cell D18 must be multiplied by 10%. However if cell D14 & D15 has a value and B18 is less than zero then the following table must be used below using a vlookup, using the cumulative value in col C i.e the 3rd column for F/end GP and 6 th col for B/end GP
[attachment=87708:Comms.xls]
However if B18 is greater than zero, then B18 must be multiplied by 10% plus following table must be used below, using the cumulative value in col C i.e the 3rd column
Your assistance will be most appreciated

20100113, 14:15 #8
 Join Date
 Feb 2008
 Posts
 1,559
 Thanks
 139
 Thanked 12 Times in 12 Posts
I am looking for a logical formula to include with a lookup function to do the following
If the value in cell D18 is less than zero then cell D11 must be zero. If the value in cellD18 is greater than zero than cell D18 must be multiplied by 10%. However if cell D14 & D15 has a value and B18 is less than zero then the following table must be used below using a vlookup, using the cumulative value in col C i.e the 3rd column for F/end GP and 6 th col for B/end GP
[attachment=87708:Comms.xls]
However if B18 is greater than zero, then B18 must be multiplied by 10% plus following table must be used below, using the cumulative value in col C i.e the 3rd column
Your assistance will be most appreciated

20100113, 14:25 #9
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 9,017
 Thanks
 63
 Thanked 1,117 Times in 1,040 Posts
I see a problem, you want to multiply D18 by 1.1 if D18 > 0? This is a looping reference and won't work in a formula.
cheers, Paul

20100113, 14:25 #10
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 9,017
 Thanks
 63
 Thanked 1,117 Times in 1,040 Posts
I see a problem, you want to multiply D18 by 1.1 if D18 > 0? This is a looping reference and won't work in a formula.
cheers, Paul

20100113, 14:25 #11
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 9,017
 Thanks
 63
 Thanked 1,117 Times in 1,040 Posts
I see a problem, you want to multiply D18 by 1.1 if D18 > 0? This is a looping reference and won't work in a formula.
cheers, Paul

20100113, 14:25 #12
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 9,017
 Thanks
 63
 Thanked 1,117 Times in 1,040 Posts
I see a problem, you want to multiply D18 by 1.1 if D18 > 0? This is a looping reference and won't work in a formula.
cheers, Paul

20100113, 14:25 #13
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 9,017
 Thanks
 63
 Thanked 1,117 Times in 1,040 Posts
I see a problem, you want to multiply D18 by 1.1 if D18 > 0? This is a looping reference and won't work in a formula.
cheers, Paul

20100113, 14:25 #14
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 9,017
 Thanks
 63
 Thanked 1,117 Times in 1,040 Posts
I see a problem, you want to multiply D18 by 1.1 if D18 > 0? This is a looping reference and won't work in a formula.
cheers, Paul

20100113, 14:25 #15
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 9,017
 Thanks
 63
 Thanked 1,117 Times in 1,040 Posts
I see a problem, you want to multiply D18 by 1.1 if D18 > 0? This is a looping reference and won't work in a formula.
cheers, Paul