Smaller of two diff cells

S

Sandy

I want one cell to show the smaller of Cell 9 or Cell

Email address (e-mail address removed)
 
G

Gord Dibben

Sandy

=MIN(A9,A2) entered in B1

BTW: makes it easier if you refer to cells by their address rather than by
Cell 9 or Cell 2

Gord Dibben Excel MVP
 

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

WordPad blocked content 2
How can the font and size of (all) citation numbers be altered? 1
increasing or decreasing a cell 16
Excel does not accept text format! 0
Need a proper guru! My head hurts ;( 1
Merging from an Excel file with graphics 1
Fill tringle in a cell with color 1
Copy addition formula of non-consecutive horizontal cells 2

Top