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.
|