small function

Im not sure if the small function is what i want to use for figure out the data im looking for.

Im doing some calculations where im adding a series of numbers and getting the sum of those numbers in cells h6, h7 and h8. my goal is to find out the smallest numer of the three cells after dividing them by differant numbers

Example h6=3,214,512
h7=1,308,168
h8=691,104
m14= (answer im looking for)

Now to get what im looking for you would need to divide cell h6 by 10,000(Answer is 321.4512). divide h7 by 6,000(Answer is 218.028). also divide h8 by 2,000 (Answer is 345.552). So the smallest answer would be 218.028 (h7/20,000) which is what im trying to get put into cell M14. The numbers im using to divide changes and my results will not always be the h8 cell being the smallest, so i cant just divide that into the result. Im sure i can always do the division first and then find the smallest number by doing 2 differant functions, but im trying to eliminate the extra cells being used. My knowledge is small on the subject but i was trying to use something along the line of

Please Login or Register  to view this content.

This is not correct of course but this might help a little more to understand what im looking for.

Thanks for any help hopefully this isnt to confusing
Kyle

Use the min function:

=min((h6/1000),(h7/6000),(h8/2000))

Hope this helps.

Thanks,

Jeff

Try this,

Please Login or Register  to view this content.