Can you provide a more detailed explanation of what you're trying to do?

There are many ways to get around a bunch of nested if statements.

--
Biff
Microsoft Excel MVP


"CC" wrote in message
...
I am having problems with 7 Nested IF functions in data validation.
What is the best way around formulas using more than 7 IF functions?
How do you write an IF function in VBA where there are more than seven
statements?
Thanks