samedi 24 octobre 2015

If Statement to fill a cell based on other cells

I have an excel document that I want to populate the values in the cells based on whether the cells below it have the value "y" or "Y" in it.

Example

Sentence String                                Y/N

       A                                        B
1  **Services**                                " "
2  Will this be for internal?                   y
3  Will you need a vendor?                      N
4  Does this task require an I/O?               N

5  **Installation**                            " "
6  Physical installation?                       Y
7  Will this take more than 2 hours?            Y

FYI: Where the string that has a **, it means the title for each group of questions. [my actual listing doesn't have the ** but just wanted to make them stand out]

What I want is, if any values within each group contain a "Y" then fill in the title with a "Y" where you see the " " in my example

I tried something like

=IF(B2="Y" or B2="y" or B3="Y" or B3="y" or B4="Y" or B4="y", B1="Y")

for first group Services but I get an error of it not being properly formatted.

Any suggestions?

Aucun commentaire:

Enregistrer un commentaire