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

Solved/Closed

JoeyM - Dec 19, 2015 at 03:18 AM
JoeyM - Dec 20, 2015 at 06:34 PM

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.

Specific price depending on the words in 2 cells? please help
Excel - IF is error with 2 cells match - How-To - Excel
2 cells match in excel - Guide
Auto copy/paste data if criteria (same value in 2 cells) is met ✓ - Forum - Excel
IF iserror with 2 cells match ✓ - Forum - Excel
Help me to count 2 cells ✓ - Forum - Excel

2 replies

Answer 1 / 2

RayH

Posts: 122
Registration date: Tuesday August 31, 2010
Status: Contributor
Last seen: June 20, 2016

25
Dec 19, 2015 at 11:31 AM

How much do each of the products cost?

joeym
Dec 19, 2015 at 06:02 PM

lets say they cost $3 per kg, thanks.

RayH
Dec 19, 2015 at 07:09 PM

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

JoeyM
Dec 20, 2015 at 01:17 AM

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 at 06:34 PM

Thanks Ray, thats awesome, problem solved. :)

Answer 2 / 2

MdRiyadHasan

Posts: 1
Registration date: Friday December 18, 2015
Status: Member
Last seen: December 19, 2015

1
Dec 19, 2015 at 08:57 AM

i thing....a3- 1kg peaches= price 10tk...

Subscribe To Our Newsletter!