Mac Forum / Applications / Excel / December 2005

Greetings,

I am trying to process sets of analytical results and am having trouble
teaching Excel how to leave out values under certain conditions.  This
process will be set up in a template spreadsheet that is then used to
correct large sets of results from a mass spectrometer.  Basically I
need to copy a value from one cell (raw data) into a new cell (valid
data) only if another cell (the test cell) contains a value (could be
positive or negative).  The test cell contains a conditional IF
statement that either copies data from another column or leaves the
cell blank based on comparison with the standard deviation of a set of
analyses.  Is there a conditional statement that I can use in an IF
statement that would return TRUE if the test cell contains a value and
FALSE if it is blank (but still contains a formula)?  I would be glad
to send along an example file to help explain my problem.  Any
assistance is appreciated.

Regards,

Bill Winston