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..

Since some of us might not speak basic, perhaps you could tell us what you
want to do.

what is the ! for
wha is DRY

--
Don Guillett
SalesAid Software

"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..

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..

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..

Thanks for your replies

DRY could be any value, in this instance its 69. i worked out the answer by
using a calculator, excel and in vba, but the same formula run through BASIC
doesnt give me the same result.

but, i think the problem is with the old program because, i wrote another
basic program with the same formula, same value for DRY and my reults match..

We think so too :)

"Jason" wrote:

Thanks for your replies

DRY could be any value, in this instance its 69. i worked out the answer by
using a calculator, excel and in vba, but the same formula run through BASIC
doesnt give me the same result.

but, i think the problem is with the old program because, i wrote another
basic program with the same formula, same value for DRY and my reults match..

anyway, atleast i know where to come again if i have problems, :)

thanks guys

As I said, it would be nice to tell us what you wanted to do

--
Don Guillett
SalesAid Software

"Jason" wrote in message
...
anyway, atleast i know where to come again if i have problems, :)

thanks guys