So what results did you get in each case? (Need the value of "DRY").

P.S. The parentheses in the second formula are redundant, i.e. they can be
removed.

"Jason" wrote:

i have a program which was written in Basic, long time back. now i am trying
to write the same program in vba, i am using the same formulas used and
everything is the same, except the user interface and things. but i am struck
on one formula which doesnt give me the result it should.

C = 18.4686 - 3827.77 / DRY - 218140! / DRY ^ 2 (old, basic formula)
C = 18.4686 - (3827.77 / DRY) - (218140! / DRY ^ 2) (formula i use in vba)

this is the formula used in basic, but when i test it in vba, i get a
different result compared to what i get in the basic program. i tried to
calculate it using excel, but i still get a different result. i really cannot
see why, because the formula is the same and why is there a difference
between basic version, and vba version ??
can anybody please help..