# Thread: Logical Function with Vlookup

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

11. 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

12. 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

13. 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

14. 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

15. 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

Page 1 of 7 123 ... Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•