ArticlesBlog

Basic Excel Business Analytics #09: Shortest Distance Shipping Costs: INDEX, MATCH, & IF Functions

Basic Excel Business Analytics #09: Shortest Distance Shipping Costs: INDEX, MATCH, & IF Functions


Comments (11)

  1. super… many thanks… ; D

  2. Nice one!
    Excellent stuff on "smart" spreadsheets.

  3. These formula are so cool. Thanks for uploading.

  4. cool…by using a formula how do i pull the values from the entire row or column just by using a single cell reference.? do you have any video of it.?

  5. You can use MAX formula to calculate Shipping Charge, like =MAX(miles*price, 75)

  6. @Francis Osuna, Glad you like it!

  7. This was amazing! I tried following this tutorial using Numbers (from Apple) and it still worked really well. Just a little slow since locking down cell references isn't quite the same as it is with Excel!

  8. I love it! Eu adorei isso! Agora em usando Excel em Ingles

  9. you make me feel proud of myself because every single day you teach me something new and i really do appreciate thank you Mr. Mike

  10. Mike great videos and energy in delivering the material, thank you again!

Comment here