make list of information from different cells
 

Hello!

I'm trying to write a string that will tell the program to look at one cell,
determine if it is emply and if it is empty (which would be true?) then add
the text from another cell to a list. Basically I'm trying to make a list of
email addresses of people who haven't finished a project.

=if
(cell_that_should_be_empty=""),the_cell_you_want_i nstead,ce
ll_that_should_be_empty)

-----Original Message-----
Hello!

I'm trying to write a string that will tell the program
to look at one cell,
determine if it is emply and if it is empty (which would
be true?) then add
the text from another cell to a list. Basically I'm
trying to make a list of
email addresses of people who haven't finished a project.
.