View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Formula/Shipping Chart

Hi,
If you're still having trouble, try this formula in E44
=VLOOKUP(E38,{0,5.95;18,6.95;24,7.95;40,8.95;50,10 .95;75,12.95;90,14.95;125,16.95;250,18.95;500,21.9 5},2,1)+E38

If you need a warning for values 600 or over, try this
=IF(E38=600,"Over $600. Use other
scale",VLOOKUP(E38,{0,5.95;18,6.95;24,7.95;40,8.95 ;50,10.95;75,12.95;90,14.95;125,16.95;250,18.95;50 0,21.95},2,1))+E38

The format of this window has wrapped the second formula, and may have added
an unwanted invisible character, which would need to be removed.
Regards - Dave.