Hi all,

I want to make a formula in which a part of that formula refers to the lowest value in a column. The formula is: 88,362 + (13,397 x weight in kg) + (4,799 x length cm) – (5,677 x age in years). In my excel sheet I have a column for weight in which I have a row for each week of the year. I want my formula to adapt to my current weight, which means that if I add a new row with data to my column I want my formula to automatically refer to that value without having to change the formula.

So if my current weight is in C34 and I add my new weight in C35, the formula automatically has to refer to the data in that cell. If I add data in C36, the formula has to adapt to the weight posted in that cell. And so on, and so on. I've tried different things and did some thorough searching, but either I haven't found a solution to this problem yet or I didn't understand potential solutions.

I hope I can find some help here