Calculating a based on criteria in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top