I'm wondering if there is a way to create a formula that will insert data and
new cells depending on an answer to an earlier question. Basically Im trying
to create a form and the next section only appears depending on the 'right'
answer.

On Sep 4, 3:39 pm, trinalyn3
wrote:
I'm wondering if there is a way to create a formula that will insert data and
new cells depending on an answer to an earlier question. Basically Im trying
to create a form and the next section only appears depending on the 'right'
answer.

This will only show up if the question is answered, you'll have to put
your info in the
=IF(xxx=yyy,zzz,"")

But if you really mean "insert" the way Excel means "insert", no
formula can do that. You would need a macro.

I've do that with drop-down menus inside drop-down menus
need to know if you want to do that


"trinalyn3" wrote:

I'm wondering if there is a way to create a formula that will insert data and
new cells depending on an answer to an earlier question. Basically Im trying
to create a form and the next section only appears depending on the 'right'
answer.