I need a, b, c, and d on this question all for #1 ...
60.1K
Verified Solution
Link Copied!
Question
Accounting
I need a, b, c, and d on this question all for #1
1 2 Bins 3 $0-$99.99 4 $100-$249.99 5 $250-$499.99 6 $500-$999.99 7 $1000- B C Zip Shipping Cutoffs Output % $ 10.00% $100.00 5.00% $250.00 4.00% $500.00 2.50% $1,000.00 0.00% 8 9 Input Order Total 10 Shipping Percentage: 11 Shipping costs: $874.00 2.50% $21.85 12 In the table above, we have 5 possibilities for the %. We represent the possibilities in a table in cells, B3:07. This table consists of two columns, #1 and #2. Basically we will LOOKUP the value for the order total B9, in the table, and then output the appropriate % from column #2. The following VLOOKUP function is entered in cell B10 which gives an output of 2.50%: =VLOOKUP(B9, B3:07,2) 1. What are the outputs for the following? (Hint: one strategy is to create the table in an Excel spreadsheet and then enter the following VLOOKUP commands.) a. =VLOOKUP( 165, B3:C7, 2) b. =VLOOKUP( 650, B3:07, 1) c. =VLOOKUP( 650, B3:C7, 2) d. =VLOOKUP( 6500, B3:C6, 2)
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
