Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do you add numeric values to lines in excel?
Well, I have data as follows:
Bla1 / March 1, 2010 / Here, nor here/
Bla2 / March 1, 2010 / Here, not here/
Bla3 / March 1, 2010 / Here, nor here/
Bla4 / March 1, 2010 / Here, not here/
I would like to add a small table below, or a total displaying the ones returned and not returned, automatically. For instance, If I already have Bla1 and Bla4, that I just wrote something on bla1&bla4 line & it would automatically show up in the table. Can this be done without adding an additional column? Thanks!
2 Answers
- 1 decade agoFavorite Answer
Refer to the following website
- 1 decade ago
u can use the following function:
=if(bla1="some sort of value let us say March 1, 2010 ", "Here", "Not here")
in words this if function says if bla1 equals march 1. 2010 then put in the cell Here if not put not here
i hope this answers ur question
