Saturday, July 16, 2011

What is wrong with this nested function in Excel?

my formula is =IF(Subtotal>=200,0,(VLOOKUP(Subtotal,Sh… Everything goes fine until I get to my VLOOKUP. I have the subtotal value that is what determines the lookup. Then on another page, I have the SHippingCost table setup. The first column is the values 0, 55, 100, and 150. These are the subtotal values. The shipping costs, respectively are 6.00, 9.50, 12.50 and 16.00. I want to show in my total formula (the one listed above) that if the subtotal is more than 200$, the shipping cost is 0. Otherwise, i want to use the table ShippingCost to determine the shipping cost. Please help. I can not figure this out.

No comments:

Post a Comment