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

A challenge for an expert...
 

=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

A challenge for an expert...
 

Here's another option:

=IF(MAX(A1:A100)=1000000,"true","")

Replace the A1:A100 portion with whatever range your actual data is in.

HTH,
Elkar


"Mary" wrote:

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

A challenge for an expert...
 

Mary wrote...
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.

=COUNTIF(ReferenceToYourRangeHere,"=1000000")0

A challenge for an expert...
 

Worked great! Thank you.
--
MaryM


"Mary" wrote:

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

A challenge for an expert...
 

I used the max one, this didn't work at first, but I'm sure its my problem
with a quotation out of place or something. Thanks!
--
MaryM


"Peo Sjoblom" wrote:

=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