Page 1 of 7 123 ... LastLast
Results 1 to 15 of 96
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    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
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    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

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    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

  4. #4
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    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

  5. #5
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    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

  6. #6
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    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

  7. #7
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    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

  8. #8
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    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

  9. #9
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 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

  10. #10
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 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

  11. #11
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 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

  12. #12
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 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

  13. #13
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 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

  14. #14
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 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

  15. #15
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 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

Page 1 of 7 123 ... LastLast

Posting Permissions

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