I'm having a hard time getting a nested IFF statement to work. I have 6 variables for each record. In a 7th cell, I'm trying to build a formula that will scan the 6 variables and determine if they contain 3 required values and report 'OK' if so, or 'Problem' if not. Summing 'successes' needs to be >= 3.
Example: The values required for 'OK' are 20, 30, 40. If all three values are not found, there is a problem.
Var 1 Var2 Var3 Var4 Var5 Var6 Result
10 20 25 30 35 40 OK
10 15 20 30 35 38 Problem
Any assistance you could provide would be appreciated!
Edited by mardiana - 14 Sep 2008 at 9:40am
IP Logged
