Formula for choosing the lesser value of multiple numbers

G

GreenMonster

I need a formula that will determin the lesser value of three cells and
return a result that is 3/8 of an inch less then the lowest value in those
cells.

Example:

Cell 1 = 51 1/2
Cell 2 = 51 3/8
Cell 3 = 51 1/8

The lowest value of the three cells is 51 1/8, so...
the result would be 51 1/8 - 3/8 = 49 3/4

Thanks
 
R

Rick B

The term "cell" is an Excel term. The newsgroup to which you posted your
question
is an Access newsgroup. We answer questions about the database application
MICROSOFT ACCESS. This is not an Excel newsgroup.

You should probably get in the habit of looking at a few posts before you
add a new thread to a newsgroup. This newsgroup has nothing to do with your
question.

I'm betting if you search the appropriate newsgroup, or google, you might
even find an answer to your question without having to ask someone to repeat
it for you.

Rick B
 
Top