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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 easy questions for someone better with Excel then me...lol 5
Function or Formula to Add lowest X number of values in a range 5
Trying to subtract the two lowest values from a row of numbers 4
using a cell value as an index reference 3
Adding a new template spread sheet on the first day of a new month 1
Help with a function 7
Form. to ignore cells w/o value from calc from previous Form. 2
Value of cell Defines Range 3

Top