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

20100113, 13:15 #1
 Join Date
 Feb 2008
 Posts
 1,411
 Thanks
 122
 Thanked 5 Times in 5 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,411
 Thanks
 122
 Thanked 5 Times in 5 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,411
 Thanks
 122
 Thanked 5 Times in 5 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,411
 Thanks
 122
 Thanked 5 Times in 5 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,411
 Thanks
 122
 Thanked 5 Times in 5 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,411
 Thanks
 122
 Thanked 5 Times in 5 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,411
 Thanks
 122
 Thanked 5 Times in 5 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,411
 Thanks
 122
 Thanked 5 Times in 5 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
 7,989
 Thanks
 46
 Thanked 952 Times in 883 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
 7,989
 Thanks
 46
 Thanked 952 Times in 883 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
 7,989
 Thanks
 46
 Thanked 952 Times in 883 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
 7,989
 Thanks
 46
 Thanked 952 Times in 883 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
 7,989
 Thanks
 46
 Thanked 952 Times in 883 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
 7,989
 Thanks
 46
 Thanked 952 Times in 883 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
 7,989
 Thanks
 46
 Thanked 952 Times in 883 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