Posts

Showing posts from January 16, 2019

Give an example of subset $B$ of the real line $mathbb{R}$ so the subsets $A$, $Int(A)$, $overline{A}$, dont...

Image
0 $begingroup$ What is an example of a subset $A$ of the real line $mathbb{R}$ (equipped with the standard metric topology), such that the subsets $A$ , $Int(A)$ , $overline{A}$ , $overline{Int(A)}$ and Int( $overline{A}$ ) are pairwise different? general-topology share | cite | improve this question edited Dec 6 '18 at 8:54 Esteban Cambiasso asked Dec 3 '18 at 11:35 Esteban Cambiasso Esteban Cambiasso 10 3

How to create the equivalent of CHOOSE using a list in a cell reference

Image
0 Selecting a specific value from a comma-delimited list can be performed with the CHOOSE function. For example: =CHOOSE(A1,"A","B","C","D") where A1 contains the index value, and "A","B","C","D" is the list. However, CHOOSE only works on an actual list embedded in the function, not a reference to a list. Suppose you have a situation where the list is dynamic, and created and stored in a cell. Say right now, cell B1 contains the comma delimited string "A","B","C","D" , and it might be a different list at another time. The requirement is still to select from that list based on the index value in A1, so the equivalent to the pseudo-code: =CHOOSE(A1,CONTENTS(B1)) Is there a way