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

Ask a question JoeyM - Latest answer on Dec 20, 2015 06:34PM
I am using excel 2008 for Mac, i need help with the following:
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 
moins plus
How much do each of the products cost?
joeym- Dec 19, 2015 06:02PM
lets say they cost $3 per kg, thanks.
RayH- Dec 19, 2015 07:09PM
in that case simply multiply the chosen value in A2 by 3 as the product is not relevant.
JoeyM- Dec 20, 2015 01:17AM
Apologies, the product is relevant, what i should have said was:
Apples = $3 per kg
Pears = $5 per kg
Peaches = $8 per kg
JoeyM- Dec 20, 2015 06:34PM
Thanks Ray, thats awesome, problem solved. :)
Add comment
moins plus
i thing....a3- 1kg peaches= price 10tk...
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!