Forum Discussion
Excel Formula
I want to create a formula that would divide the cell if it was the minimum amount of a range of cells or divide the cell that was the minimum into that cell in a range. So if A had the minimum ...
Perhaps small sample will help to understand, or rewording in terms of Excel. In particular, how A could be less than MIN(A:B). Are here the same A, does A means value in cell (A1) and A:B the range like A1:B50, or what?
I figured it out. Thanks through!
=IF(D13=(MIN($D13:$F13)),D13/(MIN($D13:$F13)),((MIN($D13:$F13))/D13))