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