• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Help in an IF and VLOOKUP nested function

    The lowest value in H37 would be 0. DO I need to modify the shipping_cost table, or do I need to modify the formula? Thanks
  2. D

    Help in an IF and VLOOKUP nested function

    I misspoke. Since H37 is 32.95, H39 should be 6.00 as it is less than 55. Thanks
  3. D

    Help in an IF and VLOOKUP nested function

    The value in H37 is 32.95. The shipping_cost table looks like this: 0 6.00 55 9.50 100 12.50 150 16.00 The order total is on the left, and the cost is on the right. Since the order is under 55, the shipping costs in H39 should read 9.50. Thanks!
  4. D

    Help in an IF and VLOOKUP nested function

    I need cell H39 to have a formula that calculates shipping costs. If the subtotal (cell H37) is greater than 200, than H39 should display 0. If H37 is less that 200, it needs to display the shipping cost based on the table named shipping_cost. I entered the formula...
Back
Top