formula help please

  • Thread starter Thread starter scott
  • Start date Start date
S

scott

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
 
work up to it gradually. First
=IF(B3="single",B9,IF(B3="married filing jointly",B10,"fillin b3"))
test>then
=IF(B2="no",B11,IF(B2="yes",IF(B3="single",B9,IF(B3="married filing
jointly",B10,"fillin b3")),"fillinb2"))
 
one way:

=IF(B2="no",B11,IF(B2="yes",IF(B3="single",B9,IF(B3="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))
 
Back
Top