Self-adding formula

[jankrulak]

Hello,

I wonder whether there is a way excel would add a formula to a new column when the new value is added to the adjacent column?

For example:

Columns B:4 and C:4 are now empty. However, when I add value to these columns, a formula from D3 would be automatically added to D4. I know, I can drag formula down, but sometimes I have 100 values and sometimes 50 000 values.

I attach a spreadsheet for the above.

Thank you advance for your assistance on this.

Kind regards,

Jan

[AliGW]

You have two options that I can think of: one is to convert the table into a structured Excel table which will force formulae to copy down when you add rows, the second is VBA.

[FDibbins]

Another option would be to already have the formula there, but to have it 1st test for data (return "" if no data), then run the calc if data is there.

Based on your formula, something like this...
=IF(B3="","",IF(ABS(C3)>ABS(B3),"FAILS","PASS"))
copied down as needed

[jankrulak]

Thank you for the responses. Much appreciated.

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[FDibbins]

Happy to help, thanks for the feedback