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.