Actually there are many ways around the 7 nested limit. One is nest 7 + nest
7

--
Don Guillett
SalesAid Software

"David" wrote in message
...
Hi,

I thought you could only nest 7 if Statements, so I am with the Select
Case
too.
--
David


"Fish" wrote:

Hello,

Is it possible to constuct a 16 constraint nested if then statement using
one equation as the control equation? Is there a better way to do this?
Please advise...

Regards,

Fish