Calculating a based on criteria in another cell

[Guest]

Hey, thanks in advance for your help. Here is what I am trying to figure out:

Options Price 70%
------------------------------------------------------------------------------------------------------------
23-2007, 23-004103 25 17.5
23-2005 35
23-004103 105 73.5
23-004103 105 73.5

Above is a partial table with a 70% discount column which needs to be calculated based on what is in the options column. How can I accomplish this? Using an if statement in the calculation, it needs to calculate only if the options contain a 23-004103 or 23-2007.

I am so not good with excel and everything I try bombs out... Please Help if you can.

Thank you very much.

Kel

 

[Guest]

Ok, that was partly wrong on my part...it needs to be the same calculation but it needs to calculate if seat=004AC AND Options=*4103* so if

4103 appears in anywhere in options AND 004AC appears in seat then calculate 70%

Thanks again, my mistake first time...



Hey, thanks in advance for your help. Here is what I am trying to figure out:

Seat Options Price 70%
------------------------------------------------------------------------------------------------------------
004AC 23-2007, 23-004103 25 17.5
004AC 23-2005 35
004AC 23-004103 105 73.5
004AC 23-004103 105 73.5

Above is a partial table with a 70% discount column which needs to be calculated based on what is in the options column. How can I accomplish this? Using an if statement in the calculation, it needs to calculate only if the options contain a 23-004103 or 23-2007.

I am so not good with excel and everything I try bombs out... Please Help if you can.

Thank you very much.

Kel


----- Kel wrote: -----

Hey, thanks in advance for your help. Here is what I am trying to figure out:

Options Price 70%
------------------------------------------------------------------------------------------------------------
23-2007, 23-004103 25 17.5
23-2005 35
23-004103 105 73.5
23-004103 105 73.5

Above is a partial table with a 70% discount column which needs to be calculated based on what is in the options column. How can I accomplish this? Using an if statement in the calculation, it needs to calculate only if the options contain a 23-004103 or 23-2007.

I am so not good with excel and everything I try bombs out... Please Help if you can.

Thank you very much.

Kel

 

[Guest]

Thanks for all of the help...

I figured it out finally, here is the answer for anyone interested in it

=IF(AND(A2="004AC", B2>="23-004103"),C2*0.7,"")

----- Kel wrote: -----

Hey, thanks in advance for your help. Here is what I am trying to figure out:

Options Price 70%
------------------------------------------------------------------------------------------------------------
23-2007, 23-004103 25 17.5
23-2005 35
23-004103 105 73.5
23-004103 105 73.5

Above is a partial table with a 70% discount column which needs to be calculated based on what is in the options column. How can I accomplish this? Using an if statement in the calculation, it needs to calculate only if the options contain a 23-004103 or 23-2007.

I am so not good with excel and everything I try bombs out... Please Help if you can.

Thank you very much.

Kel