IF AND Statement Problem

candle_66

New Member
Joined
Nov 10, 2005
Messages
22
I am trying to create a price list for my hobby poster website.

I can create drop down lists but want a IF(AND statement to auto fill depending on the size of poster selected.

I am trying to use =IF(AND(E3="Plak",M3=30),IF(E3="Mounted",M3=35),IF(E3="Print",M3=7.5,0))

Basically in cell M3 it should show 30 if Plak selected, 35 if Mounted selected and 7.50 if Print selected.

Am I missing something?
Any help much appreciated to get www.howzatposters.com up and running

Thanks

Howard
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi Candle:

How about trying the following formula in cell M3 ...

=VLOOKUP(E3,{"Plak",30;"Mounted",35;"Print",7.5},2,0)
 
Upvote 0

candle_66

New Member
Joined
Nov 10, 2005
Messages
22
Holy Smoley

Wot a numb nuts I am

I must be brain dead

Thank you very much.

regards

Howard (Candle_66)
 
Upvote 0

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi Howard:

You Are Very Welcome ... and don't be too hard on yourself ... now let us keep EXCELing!
 
Upvote 0

Forum statistics

Threads
1,191,165
Messages
5,985,040
Members
439,935
Latest member
Monty238

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top