if statements

Giganews Newsgroups
Subject: if statements
Posted by:  Brian (brian.mcgui…@parsons.com)
Date: Mon, 13 Oct 2003

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.