Carry formulas with pure logic and without the use of Array's/ Ranges or Tables possible?

[=IF(]

Hi All!

Does anyone know a work-around for being able to insert rows/ columns and carry formulas over withou using arrays or tables? E.g.

A B C D E
1
2
3
4
5

If insert a rown and have formulas in the cells above, how can I have the formulas carry over?

The reason why I can't use array formulas etc. is that this will be going into Spreadsheet gear which doesn't handle them.

Thanks!!!

 

[sijpie]

How about macros?
will it handle VBA macros?

I am assuming that want you want to achieve is that when a user inserts a row, the formulas get copied into the new row and the one below it (as it will refer to the row above?).

So that is either done manually or can be done with a macro.

Or am i completely misunderstanding the question?