=COUNTIF(Range,"=1000000")0


--
Regards,

Peo Sjoblom


"Mary" wrote in message
...
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