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 amount in a range of cells, it would divide into itself, but if it was not the minmum amount in the range, it would find the minmum amount in the range and divide that cell into it.
A< MIN(A:B) then A/Min(A:B) OR A>(MIN(A:B) then MIN(A:B)/A
2 Replies
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))
