add formula to new row

[BondJames]

Hmm.. well i don't know will i explain good and will you be able to help.
Is there any way that every time i start write data in new row that formula automatically is placed there.

For example:
I have several columes:

Dayone Answer Calc

Dayone- is colume with dates
Answer is yes or no
And in calc should go with formula IF(Answer is No, then calculate today-Dayone if answer is yes that write blank)

Is it possible to done this or it's a wild goose chase..

 

[njimack]

Yeah that is the point that users can't write "maybe" etc.. It works ok now

You can ensure users only enter Yes or No -
-Data Validation
-Allow Custom
-Formula =OR(B2="No",B2="Yes")