Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
i dont see what the problem is...
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.. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
i dont see what the problem is...
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.. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
i dont see what the problem is...
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.. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
i dont see what the problem is...
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.. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
i dont see what the problem is...
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.. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
i dont see what the problem is...
anyway, atleast i know where to come again if i have problems, :)
thanks guys |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
i dont see what the problem is...
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dont know if this is possible to do | Excel Discussion (Misc queries) | |||
Dont know what to use. | Excel Worksheet Functions | |||
I dont know if this can be done | Excel Programming | |||
Dont know how? | Excel Programming | |||
Dont allow use of VBE | Excel Programming |