I don't really know how to search for this question or an appropriate title, so I hope that this will make sense.
I'm trying to construct an excel spreadsheet to keep track of functions of a software that are currently have tests made for them. The spread sheet looks something like below where A-F are placeholders for the tests and 1-5 are placeholders for functions.
| | A | B | C | D | E | F |
|:-:|---|---|---|---|---|---|
| 1 | X | | | | | X |
| 2 | | | | | | |
| 3 | | X | | | | |
| 4 | | | X | | | |
| 5 | | | | X | X | |
I would like to have another column at the end that would do something like this:
| | A | B | C | D | E | F | Tested? |
|:-:|---|---|---|---|---|---|---------|
| 1 | X | | | | | X | Yes |
| 2 | | | | | | | No |
| 3 | | X | | | | | Yes |
| 4 | | | X | | | | Yes |
| 5 | | | | X | X | | Yes |
where the final column is an if statement that will print a conditional string base on if there are any entries in the row. I know that excel's if statements work something like this =IF(A1=10,"YES","NO") but I can't think how I would construct an if statement that would print Yes or no based on if there are any entries at all in the row.
EDIT: To add a little more detail. I've thought about constructing an if statement like this: =IF(SUM(C3:AI3)>0, "YES", "NO") and this works essentially if I use 1s or 0s instead of "X" or "O" but I'd rather use the latter. Or really I'd just rather use strings instead of integers.
Aucun commentaire:
Enregistrer un commentaire