On the Tire Prices worksheet, which functions could you use in B5 to find the pr

Question

On the Tire Prices worksheet, which functions could you use in B5 to find the price for the Model Number and Customer Type shown in B3 and B4?

Select all that apply.

AND or OR or NOT

On the Tire Prices sheet, what would be the best formula to enter in B5?

SUM Fermula Ravizw-Fxacl A mahgouh20@gmail.com File Home Insert Draw Page Layout Formulas Data Review View Tell me what you want to do Share Cut E Copy Normal 2 Annid3 Normal 1 Irsert Delrte Format Sort Find& iler Select Fommat Painter Clear FurallingTable Number Calls Edr.ing You work at Uhe wunter of Alharce Model Number: Tires. Al day long, customers came in and ask the prics an ditterent madel 4 Customer Typ: Mabr Pice What function would ??? use in BS to find e TIre Modcl and the Customer Type selected In B4 prices if they jnin the Tire Club er they Price: B3 and cutomortypes In B4 al day long so use a tormula that will wark tor all situations. Club Wholasala il Prike Member Prica 529 39 551 9 $53.00 114 9 $104 9 68 99 S67 3 109 24 5109 24 5128 24 Retirement Savings (15 pts) Test G (35 pts) escdy ? ?- O Type here to search 11:24 PM 4/8/20183

Explanation / Answer

Question is not so clear but still i would use VLookup ot match Index to derive the value so that that if the value changes in B3 or B4 values in B5 will update automatically.

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.