View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
chiajack chiajack is offline
external usenet poster
 
Posts: 3
Default Sub: Help needed!!!

Dear all,
I need help for the above question. Please help......


(chiajack) wrote in message . com...
Dear all,
I have difficulty in writing a macro for the following situation and
need help urgently on this. I would greatly appreciate any kind soul
outthere who is willing to help me out. :)

I have 2 funtions:

f = 1 + (1.4) * 2 / .005 * r
g = (1 / (1 - (1 / .005 * r))) ^ 2

I need to write a macro to incrementally calculate and display to 6
decimals, the first positive value of r such that f-g< precision where
precision will be a variable for the user to input.

Thank you.