Enter your formula in G5 to find out the PRICE under these three conditions: ITEM is "T", SIZE is "L", and COLOR is "R". C. 1 ITEM SIZE COLOR PRICE 2T 15 ITEM 3 T M 16 SIZE 4 T L. 17 COLOR 5H 28 PRICE 6 H 29 7 H 30 8T XL 18 RBRG MBR

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter1: Getting Started With Excel
Section: Chapter Questions
Problem 14RA
icon
Related questions
Question
Enter your formula in G5 to find out the PRICE under these three conditions: ITEM is "T", SIZE is "L", and
COLOR is "R".
1 ITEM
SIZE
COLOR
PRICE
2T
15
ITEM
T
3 T
M
16
SIZE
L.
4 T
17
COLOR
R.
5H
28
PRICE
6 H
M
29
7 H
30
8 T
XL
18
RBR GBBR
Transcribed Image Text:Enter your formula in G5 to find out the PRICE under these three conditions: ITEM is "T", SIZE is "L", and COLOR is "R". 1 ITEM SIZE COLOR PRICE 2T 15 ITEM T 3 T M 16 SIZE L. 4 T 17 COLOR R. 5H 28 PRICE 6 H M 29 7 H 30 8 T XL 18 RBR GBBR
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Probability Problems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage