+ Reply to Thread
Results 1 to 2 of 2

VBA Do until condition for calculating until decimals does not change (taylors formula)

  1. #1
    Registered User
    Join Date
    10-29-2020
    Location
    Slovenia
    MS-Off Ver
    365
    Posts
    9

    Question VBA Do until condition for calculating until decimals does not change (taylors formula)

    Hi guys! Im looking if anybody know how to write do until condition for calculating taylors formula until the decimal place (we decide which one) does not change anymore.
    example: I want to calculate sin(x) with taylors formula and round off result to 7 decimal places (i want corect result with 7 decimals). I need only how to write do until condition for calculating untill 7 decimals does not change anymore.
    Any idea? I did it by comparing until taylors result is same as sin(x) but its wrong because i must NOT USE sin(x).
    Thank you a lot :D
    Last edited by tzgajner; 12-22-2020 at 03:32 AM.

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: VBA Do until condition for calculating until decimals does not change (taylors formula

    Wouldn't something like this work.

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Program taylors formula
    By tzgajner in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-21-2020, 03:59 PM
  2. Replies: 2
    Last Post: 02-13-2015, 07:36 AM
  3. Formula calculating invisible decimals
    By rajre in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-11-2014, 03:56 PM
  4. Calculating Decimals
    By leena671 in forum Excel General
    Replies: 5
    Last Post: 09-20-2010, 10:11 PM
  5. auto change cell formula on condition of worksheet change in other cells
    By futurejock in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-01-2009, 12:11 AM
  6. Displaying a number with different decimals depending on a condition
    By JGarces in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-16-2006, 12:40 PM
  7. Easy calculating ending with wrong decimals
    By Ronny Andersen in forum Excel General
    Replies: 2
    Last Post: 03-09-2006, 07:29 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1