A challenge for an expert...

[Guest]

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.

 

[Peo Sjoblom]

=COUNTIF(Range,">=1000000")>0

 

[Guest]

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

 

[Harlan Grove]

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

 

[Guest]

Worked great! Thank you.

 

[Guest]

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!