B
Brian
I am attempting to write a statement to evaluate data. I
have 7 seperate values I want to analyze, and I want to
pick one value from the set of 7 with an if statement, i.e.
if value 1>0 use value 1, if value 2>0 use value 2, etc.
It works perfectly for 4 seperate values, but once I get
to 5, 6, or 7 it gives me an error end just puts #value in
the cell where I am writing this data to. Any ideas on how
to get around this or new methods of doing it? Thanks.
have 7 seperate values I want to analyze, and I want to
pick one value from the set of 7 with an if statement, i.e.
if value 1>0 use value 1, if value 2>0 use value 2, etc.
It works perfectly for 4 seperate values, but once I get
to 5, 6, or 7 it gives me an error end just puts #value in
the cell where I am writing this data to. Any ideas on how
to get around this or new methods of doing it? Thanks.