View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
if'd out if'd out is offline
external usenet poster
 
Posts: 1
Default How can I compare more than 7 items in a conditional statement?

I'm using Excel and trying to test items in conditional "if" statements for a
payroll worksheet with about 20 steps to test. Excel will only allow 7
nested "if's". Is there a way to override this limit or another way to
accomplish what I need?