A formula cannot insert new lines or do any of things you want, except return
a TRUE/FALSE on the comparison of values. You really need a macro. The
queston, though, is what kind of macro?

Do you import this data from some other application, and you'd like the
results you describe to occur after the import is complete? If so, you want
to run a routine manually after the import is complete.

Or, does a user actually use Excel to key the Input values into the cells
you've described? If this is the case, do you want something to happen after
the users completes the input on a line, or when the user indicates that
he/she is finished with the input process? If the former, then you would use
an Excel event macro, called when a cell is changed. If the latter, you're
back to running a routine manually when the user says to.

Post back with some more details, please!