View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mary Mary is offline
external usenet poster
 
Posts: 190
Default A challenge for an expert...

Data on a client's home mortgages are entered in each row in a section of the
spreadsheet. I want a lookup function that does this: if any of the
specified rows contains a value equal to or greater than 1000000 (1 million),
return "true" to the cell I'm in.
--
MaryM