# Divide top cell with lowest cell between top cel and cel I am in

I want to divide the topcel of a column with the lowest value I find between this top cell and the cell above the cell with this formula.
Could you give me the formula?

Kind regards

Eric
Ryan

I'm assuming the TopCell is Row 2.
I'm assuming your formula is is D10

To reference Column A, the the formula would be
\$A\$2/Min(\$A\$3:\$A10)

Dear Bullwinkle,

I forgot to mention that not all the cells in this region are filled.
The lowest value must be a number higher then 0

Thanks for the quick respond
This probably isn't the most efficient but will work.

=A2/MIN(IF(\$A\$2:\$A10>0,\$A\$3:\$A10,1000))

Array Formula, so used Shift+Enter after copying the formula, and it should appear inside curly braces.
Ryan

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.

Super and very quickly
I'm a little confused by your question. Given the following values in Col A, what do you want to do?