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?
|