G Guest May 21, 2004 #1 I want one cell to show the smaller of Cell 9 or Cell Email address (e-mail address removed)
G Gord Dibben May 22, 2004 #3 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
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