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

20100113, 13:15 #1
 Join Date
 Feb 2008
 Posts
 1,480
 Thanks
 135
 Thanked 7 Times in 7 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, 13:15 #2
 Join Date
 Feb 2008
 Posts
 1,480
 Thanks
 135
 Thanked 7 Times in 7 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, 13:15 #3
 Join Date
 Feb 2008
 Posts
 1,480
 Thanks
 135
 Thanked 7 Times in 7 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, 13:15 #4
 Join Date
 Feb 2008
 Posts
 1,480
 Thanks
 135
 Thanked 7 Times in 7 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, 13:15 #5
 Join Date
 Feb 2008
 Posts
 1,480
 Thanks
 135
 Thanked 7 Times in 7 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, 13:15 #6
 Join Date
 Feb 2008
 Posts
 1,480
 Thanks
 135
 Thanked 7 Times in 7 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, 13:15 #7
 Join Date
 Feb 2008
 Posts
 1,480
 Thanks
 135
 Thanked 7 Times in 7 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, 13:15 #8
 Join Date
 Feb 2008
 Posts
 1,480
 Thanks
 135
 Thanked 7 Times in 7 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, 13:25 #9
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 8,606
 Thanks
 56
 Thanked 1,055 Times in 983 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, 13:25 #10
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 8,606
 Thanks
 56
 Thanked 1,055 Times in 983 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, 13:25 #11
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 8,606
 Thanks
 56
 Thanked 1,055 Times in 983 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, 13:25 #12
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 8,606
 Thanks
 56
 Thanked 1,055 Times in 983 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, 13:25 #13
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 8,606
 Thanks
 56
 Thanked 1,055 Times in 983 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, 13:25 #14
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 8,606
 Thanks
 56
 Thanked 1,055 Times in 983 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, 13:25 #15
 Join Date
 Dec 2009
 Location
 Earth
 Posts
 8,606
 Thanks
 56
 Thanked 1,055 Times in 983 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