Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Specific price depending on the words in 2 cells? please help [Solved/Closed]

Report
-
 JoeyM -
Hello,

I am using excel 2008 for Mac, i need help with the following:

example:
A1 has a drop down box of 3 choices, apples, pears and peaches
A2 has a drop down box of 3 choices, .5kg, 1kg and 5 kgs
how do i make the relevant price appear in A3 depending on the combination chosen?

Thanking you in advance.
See more

2 replies

Answer 1 / 2
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
 24
How much do each of the products cost?
Thank you
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4218 users have said thank you to us this month

Report

lets say they cost $3 per kg, thanks.
Report

in that case simply multiply the chosen value in A2 by 3 as the product is not relevant.
Report

Apologies, the product is relevant, what i should have said was:
Apples = $3 per kg
Pears = $5 per kg
Peaches = $8 per kg
Report

Thanks Ray, thats awesome, problem solved. :)
Answer 2 / 2
Posts
1
Registration date
Friday December 18, 2015
Status
Member
Last seen
December 19, 2015
 1
i thing....a3- 1kg peaches= price 10tk...
Ask a question