ExcelBanter - max, min ratio problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - max, min ratio problem (https://www.excelbanter.com/excel-discussion-misc-queries/242461-max-min-ratio-problem.html)

nisumin

max, min ratio problem

I need to find a max, min ratio between the same fields and I'm having
trouble figuring it out. Any formula suggestions?

I'm using Excel 2007.

Gary''s Student

max, min ratio problem

If you need the ratio of the min to the max, try

=MIN(A1:A100)/MAX(A1:A100)
--
Gary''s Student - gsnu200903

"nisumin" wrote:

I need to find a max, min ratio between the same fields and I'm having
trouble figuring it out. Any formula suggestions?

I'm using Excel 2007.

nisumin

max, min ratio problem

"Gary''s Student" wrote:

If you need the ratio of the min to the max, try

=MIN(A1:A100)/MAX(A1:A100)
--
Gary''s Student - gsnu200903

"nisumin" wrote:

I need to find a max, min ratio between the same fields and I'm having
trouble figuring it out. Any formula suggestions?

I'm using Excel 2007.

That worked. Thanks Gary.

All times are GMT +1. The time now is 10:32 AM.