Enter lowest amoutn from a range of ceels into another cell?

  • Thread starter Thread starter FISH
  • Start date Start date
F

FISH

Hello all,

I have a range of amounts that will change and they are in the E column from
E11-E19. These numbers will change in my spreadsheet from time to time. How
can I enter a function in G6 that will automatically enter the lowest amount
in that range to G6.

Let's say E14 this time has the lowest entry of $100 for this example. What
function do I need to add to G6 that will automatically take that lowest
entry in the E9-E19 range and add it to G6 (so G6 would be $100 in this
example)?

Thanks.
 
Back
Top