values needed to calculate one another

[jellybeannn]

Hi,

I'm creating a web application based on an excel spreadsheet.

H42 =+(H33+H35+H36+H37+H38+H39+H40+H41+H44)*Input!G101*Input!G103
H44 =+(H43+H42+H41+H40+H39+H38+H37+H36+H35+H33)*0.004

H42 gives an answer of 616,356
H44 gives an answer of 251,991

as you can see H42 and H44 are needed to calculate one another, how can I do this in programming?

[teylyn]

Jellybeannn,

this is a circular reference. You can allow it, but it begs the question: Why?

Can you explain in context what the logic is? By the way, your formulas can be shortened to

H42 =(H33+Sum(H35:H41)+H44)*Input!G101*Input!G103
H44 =(sum(H35:H43)+H33)*0.004

... and in Excel you start the formula with just the = sign. The + sign is not required.