Find values over a certain amount

[Captain Snuggles]

I need to find a way to identify all the people who have a dollar
amount of 250 or more in two of five columns.

Name Amount1 Amount2 Amount3
Amount4 Amount5 True/False
John Doe 300 0 100
5000 0 True
Mary Yu 90 100 100
100 50 False

Any ideas?

 

[Boris]

I need to find a way to identify all the people who have a dollar
amount of 250 or more in two of five columns.

Name Amount1 Amount2 Amount3
Amount4 Amount5 True/False
John Doe 300 0 100
5000 0 True
Mary Yu 90 100 100
100 50 False

Any ideas?

How about adding an extra column with sum of the results? Something like
this:
=IF(B2>=250,1,0)+IF(C2>=250,1,0)+IF(D2>=250,1,0)+IF(E2>=250,1,0)+IF(F2>=250,1,0)
Then, you can test for value equal or greater than 2 in that column...

Regards,

B.

 

[Guest]

Maybe,

=IF(COUNTIF(B2:G2,">=250")>=2,TRUE,FALSE)

Mike

 

[Captain Snuggles]

How about adding an extra column with sum of the results? Something like
this:
=IF(B2>=250,1,0)+IF(C2>=250,1,0)+IF(D2>=250,1,0)+IF(E2>=250,1,0)+IF(F2>=250,1,0)
Then, you can test for value equal or greater than 2 in that column...

Regards,

B.

Thanks, that worked beautifully!