I have created a spreadsheet that we are using to prepare 2 different tax
returns. The spread sheet contains information on properties with 4 possible
values. We are also trying to allocate these properties into two different
trusts. I don't want to split up the information as it all relates to each
other. It has been along time since I have worked with formulas in excell.
Could anyone help me prepare a formula.

Example:
a b c d
e f g
1 01 Value 1 O1 Value 2 09 Value 1 09 Value 2
Trust 1 Trust2
2 property 1 10000
X
3 Property 1
20000
4 Property 2 10000
x

What I want is a formula if F2=X then add B2 or C2