Previous Topic Next Topic

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.
Related:

2 responses

Answer 1 / 2
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
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...

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

Hello,

i want to sum particular cells when a number consists in a cell

eg:-

=IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0)

it calculates all b77 to bh77 if any cell b81 to bh81 contains 7
i want a formula to calculate like if

b81=7, x81=7, ...... , bh81=7....

sum(b77+x77+......+bh77)

please help me to solve this issue..

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

Hello, and good morning, I have a cell with a dropdown box, to select a certain text. When I select the type of incident from a drop down box, I would like the adjacent cell to poulate with the number (eg Minor injury = 4) I have to do it for the three blank columns  Any help will be much appreciated. Thanks, Mitch.

20 responses