Try this

18.4686 - (3827.77 / DRY) - (218140! / Application.Power(DRY, 2))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Jason" wrote in message
...
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..