| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
Is that add B2 and C2?
Presuming you want to sum all of them.. =SUMIF(F:F,"X",B:B) gets B. Same with C for C. If you want to do one row at a time, then =IF(F2,"X",B2+C2) perhaps? "meganblf" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help
Or not.. =IF(F2="X",B2+C2)
"Sean Timmons" wrote: Is that add B2 and C2? Presuming you want to sum all of them.. =SUMIF(F:F,"X",B:B) gets B. Same with C for C. If you want to do one row at a time, then =IF(F2,"X",B2+C2) perhaps? "meganblf" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
