Thanks, Ernesto
I didn't use you solution, but it made me remember about how rules work.
I created 4 new fields, and then attached rules to each of the the original 4 fields to set the value of the the new fields to equal the values of the original fields as long as they met the criterea OR to set the new fields values to ...