what is the format for an input cell?
I have Office - Student and Teacher Edition 2003
I am having trouble making a table ... I try to make a Data Table and try to define $E$3:$G$16 as the range in the row input cell area so I can make this a one-input data table and then I enter C$9$ for the column cell input area a pop up pops up saying that the input (row) cell reference is invalid I hope this not a bug that can only be fixed if you have the full version of the software any clues? |
it should be $C$9
Pumaman wrote in message ... I have Office - Student and Teacher Edition 2003 I am having trouble making a table ... I try to make a Data Table and try to define $E$3:$G$16 as the range in the row input cell area so I can make this a one-input data table and then I enter C$9$ for the column cell input area a pop up pops up saying that the input (row) cell reference is invalid I hope this not a bug that can only be fixed if you have the full version of the software any clues? |
Perhaps this recent post might help in getting
the hang of setting up a one variable data table: http://tinyurl.com/562dj -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Pumaman" wrote: I have Office - Student and Teacher Edition 2003 I am having trouble making a table ... I try to make a Data Table and try to define $E$3:$G$16 as the range in the row input cell area so I can make this a one-input data table and then I enter C$9$ for the column cell input area a pop up pops up saying that the input (row) cell reference is invalid I hope this not a bug that can only be fixed if you have the full version of the software any clues? |
All times are GMT +1. The time now is 07:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com