Link to home
Avatar of Eric Zwiekhorst
Eric ZwiekhorstFlag for Netherlands

asked on

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
Avatar of Ryan
Ryan
Flag of United States of America image

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)
Avatar of Eric Zwiekhorst

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Ryan
Ryan
Flag of United States of America image

Blurred text
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.
See Pricing Options
Start Free Trial
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?

Heading
3.4
5
10
1.5

7
6
4
Mr bullwinkle's first formula works fine even if there are blanks
$A$2/Min($A$3:$A10)