I'm trying to create a formula that gives percetage of an answer thats from seperate cells

[zotah]

This is what I'm trying to solve for in a formula

If I have multiple numbers running down a column in Column Q

and I have different letters running down column R

and I have different letters running down column T

and I want to a formula to pick out only the letters that are B's in Column R and all the W's in Column T and have those 2 cominations of letters The letter B and the letter W to be multiplyed by the number in column Q by 5% and then the formula answer to be giving in Column V

Here's an example

Q R T V
7 B W Formula Answer

so the formula will see that R has a B on that Row and see that the T has a W in the same row and then look at the number in Q and mulitply that number 7 by 5% and then give the formula answer in V which in this case the answer would be 7 times 5% which is .35

But if let's say the R said P or any other letter then the formula would give an answer of nothing because it didn't meat the qualifications to figure anything out. Likewise if the column T did not have a W in it lets say it had the Letter O or any other letter besides the Letter W then the formula would not figure anything out because both the Column R and the Column T both have to have a letter B and Column T would have to have the letter W in order for anything to be figured.

I then need to be able to drag this formula down the column so it will calculate every matching figure all the way down the excel page.

so here's another more expanded example of what I mean exactly

Column.Q...............R...............T..................V....................

........... 7...............B...............W..................Formula Answer of .35 (Because the B and W are both in the same row)
...........3................P...............O.................No Answer 0 (Because B and W were not both in the same row at the same time)
...........5................P...............W.................No Answer 0 (Because B and W were not both in the same row at the same time)
...........2................B...............W.................Formula Answer of .10 (Because the B and W are both in the same row)
...........0................B...............W.................Formula Answer of .00 (Because the B and W are both in the same row)
..........12...............B................L..................No answer 0 (Because B and W were not both in the same row at the same time)
..........21...............P................L.................No Answer 0 (Because B and W were not both in the same row at the same time)
.........5.................B................W.................Formula Answer of .25 (Because the B and W are both in the same row) Etc.


So if the Column R and The Column T are both B and W then the formula will take the number in Column Q and multiply it by 5% and give the answer in the same row in Column V If the letters don't match in Column R and Column T then an answer of 0 Zero will be the answer because no calculations are need for that comination of letters.

Thanks for any help you can give me

Zotah

 

[Latchmaker]

Place in V2 if there is a header and fill down
=IF(AND(R2="B",T2="W"),Q2*0.05,0)

 

[etaf]

in V2 put (assuming you have "headings in row 1) if not and you want to start at row 1 - change the row from 2 to 1
=if( AND(R2="B", T2="W") , Q2*0.05, "")
copy down the column

 

[zotah]

Place in V2 if there is a header and fill down
=IF(AND(R2="B",T2="W"),Q2*0.05,0)

Formula works perfectly

Thanks So much

Zotah

 

[zotah]

in V2 put (assuming you have "headings in row 1) if not and you want to start at row 1 - change the row from 2 to 1
=if( AND(R2="B", T2="W") , Q2*0.05, "")
copy down the column

Thank You for the formula

zotah