max, min ratio problem

nisumin · Sep 12, 2009

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 · Sep 12, 2009

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

=MIN(A1:A100)/MAX(A1:A100)

nisumin · Sep 12, 2009

Gary''s Student said:
If you need the ratio of the min to the max, try

=MIN(A1:A100)/MAX(A1:A100)