Maybe. On Thu, 29 Jun 2006 14:03:02 -0700, rnrxtreme Gord Dibben MS Excel MVP
G Gord Dibben Jun 29, 2006 #1 Maybe. On Thu, 29 Jun 2006 14:03:02 -0700, rnrxtreme Gord Dibben MS Excel MVP
O Otto Moehrbach Jun 29, 2006 #2 I don't know what you want to do. If you want a cell to display the result of a calculation like 14/7, type "=14/7" without the quotes, in a cell and hit Enter. HTH Otto
I don't know what you want to do. If you want a cell to display the result of a calculation like 14/7, type "=14/7" without the quotes, in a cell and hit Enter. HTH Otto
R Ragdyer Jun 29, 2006 #3 If C1 contained =14/2 Then you could display: A7 with =INDEX(A:A,C1) OR G1 (7th column) with =INDEX(1:1,C1) You could also use Indirect: A7 =INDIRECT("A"&C1)
If C1 contained =14/2 Then you could display: A7 with =INDEX(A:A,C1) OR G1 (7th column) with =INDEX(1:1,C1) You could also use Indirect: A7 =INDIRECT("A"&C1)
