In the shipping cell (H29), enter a formula that nests the VLOOKUP function in a

Question

In the shipping cell (H29), enter a formula that nests the VLOOKUP function in an IF function to look up the shipping cost from the Shipping Cost table in the Pricing and Shipping worksheet based on th subtotal in cell H27. If the subtotal is 0, the shipping cost should display 0. (Hint used the defined name you created for the Shipping Cost table data.)

- I am completely stumped on this question please help!

Home Insert Fage Layout ormulas Data Revie Foxit PDF Tell me what you wantto do AutoSumA Wrap Tex Consolas 11 A A General copy , Paste 1 u . . 2-. $. %, Conditional Format as Cel Inser. Delete Format Formatting Table StylesT Merge & Center- Format Pairter ClearFilte Clipboard Font Alignment Numbe Styles Cells Eciting H29 9 Sold to 10 Lauri Bradford 226 South Street 1 Havwtiorne HV 89415 tem Flavor Price Total 1 Gourme 17 13 19 20 21 Nacho Cheese n tin 1 $ 5.00$ 5.00 23 25 27 Notes: Subto:al5.00 Sales Tax 034

Explanation / Answer

Try this one

=IF($H$27=0,0,VLOOKUP($B$29,$B$15:$H$26,7,0))

I am assuming b29 contains the word "shipping cost". The formula looks for the same in column B (B15:B26) only if H27 is not zero. Then returns the corresponding value in column H which is the cost.

If H27 is equal to zero, it will return zero

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---