max, min ratio problem

N

nisumin

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.
 
G

Gary''s Student

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

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