If/Then Statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know a way around the 7 nested statements rule? I have 15 possible combinations

Thank
 
When you need more than 2 or 3 IFs, your best bet is to
use a lookup table or some other formula. Be more specific
about what you're trying do, include some sample data, and
the explain the layout of your data.

HTH
Jason
Atlanta, GA
-----Original Message-----
Does anyone know a way around the 7 nested statements
Click to expand...
rule? I have 15 possible combinations?
 
Thanks Jason. After speaking with the person I was trying to help and finding out more about the problem, we did decided to use a lookup table instead

Barbi
 
Back
Top