Problem with creating two variable data table

[sudhanshu]

Presently I am unable to set up a formula in a cell for two inpu
variable. I have gone through EXCEL help on how to create two variabl
data table but unable to do so. There may something wrong in formula.

I have done the following :

Inserted a formula in cell D20 which read as : D21^2+E20^2-4.
Keyed in a set of inputs in same column below the cell in which formul
is written i.e. D2126 and keyed in another set of input in same ro
in the cell that is at the right of formula cell i.e. E20:J20.

Always one message comes "Input cell reference is not valid". Ther
must be something wrong with formula or the placing of input data
however, I am unable to decipher it. Please help.

Thanks
Sudhansh

 

[Peter Atherton]

Sudhanshu

Seems alright to me but you must precede a formula with
the equal sign

=D21^2+E20^2-4 works properly

Regards
Peter

 

[Bernie Deitrick]

Sudhanshu ,

If your numbers are in D2126 and in E20:J20, try entering this in
Cell E21:

=$D21^2+E$20^2-4

then copy that cell to E21:J26, and you should get your table.

The $s fix the references so that they don't update when you copy, and
they will always refer to the correct column and row of your table
values.

HTH,
Bernie
MS Excel MVP

 

[sudhanshu]

Hey Bernie

It is woking

Thanks for your help.
Sudhansh