Find values over a certain amount
 

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?

Find values over a certain amount
 

On Thu, 20 Sep 2007 16:02:25 -0000, Captain Snuggles wrote:

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)+I F(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.

Find values over a certain amount
 

Maybe,

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

Mike

"Captain Snuggles" wrote:

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?

Find values over a certain amount
 

On Sep 20, 9:11 am, Boris wrote:
On Thu, 20 Sep 2007 16:02:25 -0000, Captain Snuggles wrote:
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)+I F(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!