I need to use a lookup formula to have Cell X = .63 by having the formula look up the shipping rate for the extended Cost (12.50) then comparing it to the Extended $ in the lower table. Picture attached for better visual.
Extended Shipping
$12.50 Cell X
$91.45
$130.00
$37.50
$65.00
$81.00
Extended $ Rate
0 1%
10 5%
100 10%
Bookmarks