Home » Forums » Open Source Learning Center » Question and Answer

what if>data table assistance

Submitted by MRE054 on 5 April, 2013 - 08:41

Hello Guys,

I am struggling to get one formula right in my assignment.
In what if>data table, how do we use a formula as our reference cell?

Please check attached image, the annual operating cost formula is =C4*12+C5+C6+C7+C10*C8
but when using data table when I use as cell reference the cell I created with this formula, it returns in the same value for all table.

Please assist.

Regards,
Mahomed Ramiz

example
‹ Copy and paste from one tab into another with certain rules using VBA Multiple list dropdown ›
»
Almir's picture

To select Row/Column

Submitted by Almir on 17 April, 2013 - 06:51.

To select Row/Column references, you need row/column with variables. Formula cell is separate cell. You need to add columns to right from formula cell and to add rows below the formula cells. Fill in the variables, select formula cell and then down and right. Then use Data Table option. If you need additional assistance, send me e-mail.

»