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
LVL 6
Eric ZwiekhorstSAP Business ConsultantAsked:
Who is Participating?
 
RyanProject Engineer, ElectricalCommented:
Actually, you don't need the false part of the if. So the following works, with Shift+Enter.
=A2/MIN(IF($A$2:$A10>0,$A$3:$A10))
0
 
RyanProject Engineer, ElectricalCommented:
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)
0
 
Eric ZwiekhorstSAP Business ConsultantAuthor Commented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
RyanProject Engineer, ElectricalCommented:
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.
0
 
Eric ZwiekhorstSAP Business ConsultantAuthor Commented:
Super and very quickly
0
 
Martin LissOlder than dirtCommented:
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
0
 
EirmanChief Operations ManagerCommented:
Mr bullwinkle's first formula works fine even if there are blanks
$A$2/Min($A$3:$A10)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.