View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shadowman13 Shadowman13 is offline
external usenet poster
 
Posts: 3
Default Conditional display

I have a worksheet wherein there's a cell that displays the "minimum" number
from a group of five [or more] numbers; each of those five [or more] numbers
is associated with a "text statement".

Is there a formula I can employ, that would allow me to display, in a cell,
the "text statement" associated with the minimum number? My goal is to be
able to automatically display [based on which number is the minimum] the
associated text statement. Thus the reader of the worksheet will see
displayed the text statement associated with the appropriate minimum number.

Thanks!
--