Formula help

[ranthrave]

Hello sir! I have a problem in constructing a formula in matrices especially in reciprocal.
Let say I have a 4 column (column A & column B are the choices, Column C is your choice, and Column D is the random intensity.
What could be the formula in cell H3? IF the user choose A then H3 is 3/2 or 1.5. If the user choose B then H3 is 2/3.

Excel 2007<table style="background-color: rgb(255, 255, 255); border: 1px solid rgb(166, 170, 182); border-collapse: collapse;" cellpadding="2.5px" rules="all"><colgroup><col style="background-color: rgb(224, 224, 240);" width="25px"><col><col><col><col><col><col><col><col><col></colgroup><thead><tr style="background-color: rgb(224, 224, 240); text-align: center; color: rgb(22, 17, 32);"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr><td style="color: rgb(22, 17, 32); text-align: center;">2</td><td style="font-weight: bold; text-align: center;">A</td><td style="font-weight: bold; text-align: center;">B</td><td style="text-align: center;">Better A or B?</td><td style="text-align: center;">Intensity</td><td style="text-align: right; border-right: 1px solid black;">
</td><td style="text-align: right; border: 1px solid black;">
</td><td style="text-align: center; border: 1px solid black;">Apple</td><td style="text-align: center; border: 1px solid black;">Banana</td><td style="text-align: center; border: 1px solid black;">Orange</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">3</td><td style="">Apple</td><td style="">Banana</td><td style="text-align: center;">B</td><td style="text-align: center;">1.5</td><td style="text-align: right; border-right: 1px solid black;">
</td><td style="border: 1px solid black;">Apple</td><td style="text-align: center; border: 1px solid black; background-color: rgb(255, 255, 0);">1</td><td style="text-align: center; border: 1px solid black;"> 2/3 </td><td style="text-align: center; border: 1px solid black;">5 </td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">4</td><td style="">Apple</td><td style="">Orange</td><td style="text-align: center;">A</td><td style="text-align: center;">5</td><td style="text-align: right; border-right: 1px solid black;">
</td><td style="border: 1px solid black;">Banana</td><td style="text-align: center; border: 1px solid black; background-color: rgb(255, 255, 0);">1 1/2 </td><td style="text-align: center; border: 1px solid black; background-color: rgb(255, 255, 0);">1</td><td style="text-align: center; border: 1px solid black;">3</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">5</td><td style="">Banana</td><td style="">Orange</td><td style="text-align: center;">A</td><td style="text-align: center;">3</td><td style="text-align: right; border-right: 1px solid black;">
</td><td style="border: 1px solid black;">Orange</td><td style="text-align: center; border: 1px solid black; background-color: rgb(255, 255, 0);"> 1/5</td><td style="text-align: center; border: 1px solid black; background-color: rgb(255, 255, 0);"> 1/3</td><td style="text-align: center; border: 1px solid black; background-color: rgb(255, 255, 0);">1</td></tr></tbody></table>

Sheet5​

<table width="542" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height: 15pt;" height="20"><td class="xl70" style="height: 15pt; width: 48pt;" width="64" height="20">
</td><td class="xl70" style="width: 48pt;" width="64">
</td><td class="xl67" style="width: 60pt;" width="80">
</td><td class="xl67" style="width: 48pt;" width="64">
</td><td class="xl66" style="width: 11pt;" width="14">
</td><td class="xl68" style="width: 48pt;" width="64">
</td><td class="xl69" style="border-left: medium none; width: 48pt;" width="64">
</td><td class="xl69" style="border-left: medium none; width: 48pt;" width="64">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl66" style="height: 15pt;" height="20">
</td><td class="xl66">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl66">
</td><td class="xl68" style="border-top: medium none;">
</td><td class="xl73" style="border-top: medium none; border-left: medium none;">
</td><td class="xl72" style="border-top: medium none; border-left: medium none;">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl66" style="height: 15pt;" height="20">
</td><td class="xl66">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl66">
</td><td class="xl68" style="border-top: medium none;">
</td><td class="xl74" style="border-top: medium none; border-left: medium none;">
</td><td class="xl73" style="border-top: medium none; border-left: medium none;">
</td></tr><tr style="height: 15pt;" height="20"><td class="xl66" style="height: 15pt;" height="20">
</td><td class="xl66">
</td><td class="xl67">
</td><td class="xl67">
</td><td class="xl66">
</td><td class="xl68" style="border-top: medium none;">
</td><td class="xl75" style="border-top: medium none; border-left: medium none;">
</td><td class="xl75" style="border-top: medium none; border-left: medium none;">
</td> </tr> </tbody></table>

 

[MrVillareal]

Hi try this one.

Excel Workbook
	C	D	H
1	B	1.5	2/3
Sheet7

Excel 2010

Cell Formulas
Range	Formula
H1	=IF(C1="A",D1,1/D1)

 

[ranthrave]

tnx sir

 

[MrVillareal]

Welcome