copy cell contents based on another cell's content

[bill]

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

 

[JE McGimpsey]

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.

One way:

=IF(testcell="",rawdata,"")

 

[bill]

That is a winner! Thanks very much.