If cell containts multiple text criteria, then return specific values

[CAMARD2]

Hey guys,

I need some help. So right now I have a drop down list in place in cell A39. It contains 5 options (credit card, line of credit, loan, car rental, other)


I'm trying to set up a formula in cell F39 so that when "credit card" or "line of credit" is chosen in cell A39, it will take 3% of the value I have in cell E39 (so E39*3%), when the other 3 options are chosen, I want it to return a 0.


I have a formula in place right now which is: =SI(A39="Credit card";E39*3%;0) but I'm not sure how to get the formula working if I want the same to be done for when "Line of credit" is chosen. BTW my excel is in French, SI = IF. If you have a solution you can give the formula in English and I will convert it to French.

Thanks in advance!

 

[gaz_chops]

Try

=if(or(A39={"Credit card","line of credit"}),E39*3%,0)

 

[CAMARD2]

That works. Thanks!

 

[gaz_chops]

you're welcome