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