Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help please
Hello. I am trying to get a formula that will do the
following which I will say in plain english. If B2=no, then B11. On the other hand, if B2=yes, then the answer could be either b9 or b10. It would be b9 if b3=single, and b10 if b3=married filing jointly Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help please
work up to it gradually. First
=IF(B3="single",B9,IF(B3="married filing jointly",B10,"fillin b3")) testthen =IF(B2="no",B11,IF(B2="yes",IF(B3="single",B9,IF(B 3="married filing jointly",B10,"fillin b3")),"fillinb2")) -- Don Guillett SalesAid Software "scott" wrote in message ... Hello. I am trying to get a formula that will do the following which I will say in plain english. If B2=no, then B11. On the other hand, if B2=yes, then the answer could be either b9 or b10. It would be b9 if b3=single, and b10 if b3=married filing jointly Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help please
one way:
=IF(B2="no",B11,IF(B2="yes",IF(B3="single",B9,IF(B 3="married filing jointly",B10,"")),"")) Depending on your data, that could be shortened a bit. If B2 can *only* be yes or no, or if it's not no, it should be assumed to be "yes", then: =IF(B2="no",B11,IF(B3="single",B9,IF(B3="married filing jointly",B10,"")) Likewise, if B3 can only be single or married filing jointly, then: =IF(B2="no",B11,IF(B3="single",B9,B10)) In article , "scott" wrote: Hello. I am trying to get a formula that will do the following which I will say in plain english. If B2=no, then B11. On the other hand, if B2=yes, then the answer could be either b9 or b10. It would be b9 if b3=single, and b10 if b3=married filing jointly Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |