Repeated Excel Calculation

[Pavan Kumar]

Hi All,

I want a method to repeatedly do a calculation using varying input values taken from an excel column and report it back to another excel column. Can this be done without using VBA?. If yes please suggest.

This is required for my project where I want to calculate tank heat loss when the tank level is varying( in an excel column) and report back.

Thanks and Regards,
Pavan Kumar

 

[pmover]

sure . . .

in a column, the tank level is the variable.

in the adjacent column, the tank heat loss is determined.

in the rows below the first tank level value, have the same formula in column for tank heat loss using the tank level in same row.

continue calc for as many rows as needed.

 

[shvet]

Study options in "Data" => "What if analysis"