LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 367
Default 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..


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dont know if this is possible to do pinmaster Excel Discussion (Misc queries) 0 February 3rd 06 11:21 AM
Dont know what to use. BRIAN Excel Worksheet Functions 1 January 25th 06 07:45 AM
I dont know if this can be done BlenderGuy[_2_] Excel Programming 0 October 15th 04 05:44 AM
Dont know how? Krefty[_3_] Excel Programming 1 December 15th 03 10:43 AM
Dont allow use of VBE Steven Revell[_2_] Excel Programming 1 October 16th 03 04:05 PM


All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"