Question
Calcule el costo del flete de envo, siga la zona, obtuve esta tabla de peso y zona de envo ahora, no s cmo combinarla con
Calcule el costo del flete de envo, siga la zona, obtuve esta tabla de peso y zona de envo ahora, no s cmo combinarla con la zona y determinar la tasa de peso en la segunda tabla, por favor ayuda, he intentado usar INDEX MATCH pero no trabajo.
| Peso de envo en libras | Zona |
| 3.4 | 4 |
| 2.0 | 45 |
| 1.0 | 3 |
La tabla del grfico de zonas es esta:
| Zonas | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46 |
| 1 libra | $8.76 | $9.09 | $9.91 | $10.35 | $10.71 | $10.83 | $11.01 | $32.71 | $33.63 | $43.09 |
| 2 | $9.42 | $10.48 | $11.33 | $11.58 | $12,08 | $12.54 | $12.75 | $36.39 | $37.66 | $46.76 |
| 3 | $9.90 | $11.04 | $11.94 | $12.43 | $12.94 | $13.38 | $14.03 | $39.54 | $42.90 | $49.79 |
| 4 | $10.19 | $11.11 | $12.32 | $13.12 | $13.48 | $14.36 | $15,03 | $43.42 | $45.73 | $54.01 |
Ayuda con la frmula para buscar la zona y el peso coincidente para obtener la cotizacin de Excel!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Process Audits And 6 Sigma Excellence To Mitigate Risk And Improve Business Performance
Authors: Mr Indulis Laimonis Svikis
1st Edition
B09M5FPYR4, 979-8769768996
