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

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

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