View Single Post
  #1   Report Post  
jimmyJ
 
Posts: n/a
Default Nesting more than 7 variables in IF equations


Sorry if this is a repeat anywhere but I am stumped.
I am trying to create a simple IF Formula with 9 variables. My
objectives are to mark tests that require 9 codes per answer. They can
be inputed in any order. ( you can see why the IF function would be my
first choice.) I only require the outcome to be either , 1 or 0 as an
answer. Can anyone help me with a suitable solution. I am not even sure
which Function would best suit me at this point.

Thanks!


--
jimmyJ
------------------------------------------------------------------------
jimmyJ's Profile: http://www.excelforum.com/member.php...o&userid=28307
View this thread: http://www.excelforum.com/showthread...hreadid=478809