If-Then Text statement

[william.healy]

Hope I've understood the question!

=IF(C7="","blank","enter name") based on this being in
column F.

-----Original Message-----
I asked this question last week, but can't find the

question or responses in the discussion group.

I need to create an if-then statement in an excel

spreadsheet for student evaluations.

I need it to say that if there is a student name in cell

C7 then there must be a comment in F7.

 

[Guest]

Good morning William

In English, the formula would read, "If C7 has a name in it then F7 must have a comment, otherwise F7 is blank" I just need to know how to write this in Excelese

Thank

----- (e-mail address removed) wrote: ----

Hope I've understood the question

=IF(C7="","blank","enter name") based on this being in
column F

-----Original Message----
I asked this question last week, but can't find the

question or responses in the discussion group.C7 then there must be a comment in F7