Hello,
Trying to calculate shipping cost from table on seperate sheet.If shipping is over $200 than its free otherwise need to lookup value on seperate sheet. On the seperate sheet have table shipping with 2 columns.one with subtotal amount i.e (0-54.99) and then second column cost at 5.95. the following was my formula which doesn't work.
=if(h38>=200,0,Vlookup(h38,shipping,2,0)).
Thanks-jeromephoto![]()
Bookmarks