IF AND Formula HELP

Hi All!

I am trying to create something totally out with my capabilities so hope you can help...…

I have created a table from which I have created a list, when I choose these items from a list I want them to add different data to different cells...

For Example...

=IF(A6="PL202 Type W","0.5","0") but I want "0.5" to be multiplied by B6 which is a number AND only IF B6 >0 (this is the easy part hopefully)

I also want

=IF(A6="PL202 Type W","14","0") but I also want different permutations too such as =IF(A6="PL202 Type X","6","0") but I want them to all add together in one cell as there may be 20 different options from 20 different cells.

Really hope you can help.

Thanks in advance

this takes care of your first condition... =IF(AND(A6="PL202 Type W",B6>0),B6*0.5,0)
the problem I see is that your second condition IF(A6="PL202 Type W","14","0") is the same condition as the first one except you want the output as 14 instead.
AND, BTW, remove the quotes from around the numbers "14" and "0" because these are changing the numbers to text so down stream from there you cannot add them or do other math on them without changing them back.

AND too, Pete asked you to put in your sample before and after and I would add, expected outcomes. You state you want them all to add together and possibly 20 different options and 20 different cells, we're not mind readers so we don't know exactly what you are adding and what your inputs and expected outcomes should be so you need to add more information.

We have the forum rules posted under that link at the top of this post. You are not (to my knowledge) in violation of any rules so far. We just try to give you advice that will help you get the best answer possible and hopefully you'll learn some excel along the way.

Now, as for this... =IF(AND(A6="PL202 Type W",B6>0),B6*0.5,0) or =IF(AND(A6="PL202 Type X",B6>0),B6*0.5,0) or =IF(AND(A6="THAL",B6>0),B6*0.5,0) usually the way to handle a series of if then statements is to make the next if follow on the last one so it would look like this...
=IF(AND(A6="PL202 Type W",B6>0),B6*0.5,IF(AND(A6="PL202 Type X",B6>0),B6*0.5,IF(AND(A6="THAL",B6>0),B6*0.5,0)))
where the last one has the final 0 as the alternative.
another shorter way to write you have (just with those three if thens) is =IF(AND(OR(A6="PL202 Type W",A6="PL202 Type X",A6="THAL"),B6>0),B6*0.5,0)
There is also the possibility to use sumproduct or set up a vlookup table or an index/match if you have multiple inputs for A6 but a lot of the same for the outputs.
So simplifying what you are posting and showing us the extent of what you have and need can help us better help you.
And welcome to the forum, we'd rather be helpful than annoying about rules.

now getting toward the bottom of your post I see that you have this...
=IF(AND(A6:A20="PL202 Type W>0),B6:B20*0.5,0)
the ranges are what will create problems. If you do it one at a time you should be find for an if/then.
but if you are doing a range you might want to use a different formula like this..
IF(COUNTIFS(A6:A20,"PL202 Type W",B6:B20,">"&0)>0,SUM(B6:B20)*0.5,0)

Hello kevjkeenan and Welcome to Excel Forum.
A somewhat 'low tech' option would be to expand the 'table at the right hand side' to include the number of units then multiply by the number required for each unit of each product. You could then use a straight assignment i.e. B78: = AR13
Let us know if you have any questions.