Help using the "IF" function, please

[denisecook]

Hi, I have a spreadsheet survey that lists employees names and a fiel
for the user to put an "x" in to opt out of the survey. If they put a
X in this field then I want the X to automatically repeat all the wa
down the column for every row that contains an employee name. That wa
it will essentially x out each listed employee but won't put x's in row
that are blank.

I'm trying to use an IF function, for instance, in cell C3 to say, i
plain terms, if cell C2 contains an X, AND cell A7 (the employee name
is NOT BLANK, THEN put an X here also, ELSE leave this cell blank.
This would repeat all the way down so if the user opts out, all of hi
employees would receive the x, or else it would stay blank.

Any ideas? I've been playing around with the IF function using th
function toolbar but its complicated.

I appreciate your help. :cool

 

[Max]

One way .. if I've read it correctly

Try in C3: =IF(AND(TRIM(C$2)="X",NOT(ISBLANK(A$7))),"X","")
Copy C3 down

 

[denisecook]

THANK YOU THANK YOU THANK YOU!!!!

That worked perfectly on first try! This is going to help me SOOO
much because some users have 30 employees and they've been complainin
about having to sit and repeat info for each one.

Again, thank you 100x

 

[Max]

You're welcome !
Pleased to hear it worked ..

 

[denisecook]

Hi,

That formula is working so well for me that I thought I'd try to mak
my form even more user-friendly.

The form goes out with employee info already filled out on each row
along with the supervisor name, so each row is a record. If the use
has to add employees, they would of course start at column A and ente
the names but I want to save them from entering redundant info such a
the supervisor name/phone number and email. What I'd like is a simila
formula to go in, for example, cell AJ7, that says, if A7 (employe
name) is not blank, then copy down AJ6 (what's in the field above whic
would be supervisor name). Therefore the user would just enter th
employee name and the supervisor name would automatically copy down
each form only belongs to one supervisor so the data would jus
continue filling down as you add employees. I would use this sam
formula for supervisor phone and email columns.

Once again, any help is much appreciated

 

[Max]

Assuming employee names would be entered in A7 down,
with the supervisor's name in AJ6 ..

Try in AJ7: =IF(ISBLANK(A7),"",AJ$6)
Copy AJ7 down

 

[denisecook]

Once again, your solution is perfect on the first try!

I've searched for some references online but didn't find much - coul
you recommend a good book on using VB with Microsoft Office? I jus
finished a VB.NET class but we didn't focus on Office at all and that'
where I would use it the most.

Again, I appreciate your help so much! My form is going to make such
great impression and I can't thank you enough

 

[Max]

Glad to hear it worked !
Thanks for the feedback

As for ..

.. recommend a good book on using VB with Microsoft Office?

um.. guess I'm not into the subject enough to be in a position to do so
but you might want to try Debra Dalgleish's Excel book list at:
http://www.contextures.com/xlbooks.html