Does anybody know if it is possible to attach 2 values to a cell in excel ?
ie to then format/do equations in other cells but selecting one of those 2 values ?
Thanks
2007-04-01 03:26:43 · 6 answers · asked by phaedrus 1 in Society & Culture ➔ Languages
I'm not sure what you are asking but try the Microsoft office office training site which has several user guides
http://office.microsoft.com/en-gb/training/CR061831141033.aspx
2007-04-01 03:39:37 · answer #1 · answered by clint_slicker 6 · 0⤊ 0⤋
No disrespect to others who answered, but I think you can do this (sort of) using a drop down validation. For people using the sheet, multiple values "appear" to be in one cell. The user can choose one and then that value will display. Subsequently, you can have other cells use the value to perform calculations and lookups, etc.
So maybe it was just the way you worded your question that has others confounded? It is true that you can assign only one value or one formula to single cell, but validation gives an appearance otherwise. That is why i want you to read another answer I posted. Click here:
http://answers.yahoo.com/question/index;_ylt=AugWU01EC8SOO0Npyw1iZRfsy6IX?qid=20070401080100AAoijk0&show=7#profile-info-28e0b2aea0aa8f6c8c3fd26f9e22c1b9aa
Sometimes when posting questions, people don't always explain what they want in terms that everyone understands. Yet I read your question and context with a different attitude that makes me believe a drop down validation listing will solve your problem.
Hope this helps!
QwertyKPH @ Yahoo!
2007-04-02 06:08:56 · answer #2 · answered by qwertykph 4 · 0⤊ 0⤋
The first answer had me wasting 10 minutes reading parts of a guide-book to Excel. I'm convinced the answer is 'no' as each cell accepts a unique entry. I suggest you use an adjacent cell for the second entry.
2007-04-01 04:22:08 · answer #3 · answered by JJ 7 · 0⤊ 0⤋
Never heard of it being capable of this.
What would be the purpose? Just use another cell for a different value. Formulas in another cell can refer to one, and/or the other. "If statements" can often be used in this case.
2007-04-01 03:39:04 · answer #4 · answered by ed 7 · 0⤊ 0⤋
Wrong section, but fortunately I know the answer ...
no, that is not possible. Cells with assigned numeric values can only have unique values.
2007-04-01 03:36:25 · answer #5 · answered by Cosimo )O( 7 · 0⤊ 0⤋
I think so. If you ask in the help, it should explain it. You need to separate the equations with a character, and I can't remember what it is, sorry!
2007-04-01 03:33:51 · answer #6 · answered by Dogsbody 5 · 0⤊ 0⤋