+ Reply to Thread
Results 1 to 4 of 4

Formula, or iterative calculation error?

  1. #1
    Registered User
    Join Date
    08-15-2019
    Location
    CT, USA
    MS-Off Ver
    Excel 2016
    Posts
    11

    Formula, or iterative calculation error?

    Hello all. First time posting here so please, be gentle :D

    I have a workbook that is referencing data from a one sheet within the document to another. Simply put, I am incorporating the value from a formula into a string of text that will update itself (Sheet 1, cell C1). I've created this dummy file that has the formulas I am using.

    Sheet 1:
    "Desired": outcome from the formulas I'm using as I would like to see it.

    "What I get": This is an image from my actual spreadsheet that uses the same formula but is returning an absurd amount of values past the decimal. If the image is not displaying within the .xls I have also attached a screenshot (sample1.jpg)

    Database tab: This page houses the various points of data that the formula on sheet one will pull from, specifically the "Remainder after Expenses" cell K14.

    Addendum: I noticed after building this sample file that the Desired outcome is calculation to 3 decimal places when it should be 2.

    TLDR: How do I force the formula in cell C1 of Sheet1 to only display to 2 values past the decimal? Formatting the cell to "Currency" or "Accounting" does not work. Is this an issue with the iterative calculations? I have reset my files to their default settings and this does not correct it.

    The original file I am working with is too large and has too much private data to share openly, but The formulas I am using and the setup/presentation of all data is largely the same.

    Thanks for any help!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Formula, or iterative calculation error?

    the value in c1 is text so formatting wont work

    ="Expenses Per Week (Utilizing Remaining Income Total "&TEXT(Database!K14,"$0.00")&" week)"

    any better?

  3. #3
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Formula, or iterative calculation error?

    With the text formula:

    ="Expenses Per Week (Utilizing Remaining Income Total $"& TEXT(Database!K14,"0.00")&" week)"

  4. #4
    Registered User
    Join Date
    08-15-2019
    Location
    CT, USA
    MS-Off Ver
    Excel 2016
    Posts
    11

    Re: Formula, or iterative calculation error?

    It does! Thank you for the reply! I was able to apply this to similar one that also had a basic mathematical formal in it and it worked perfectly!

    Ref: ="(Difference: "& TEXT(SUM(G31-H31),"$0.00") &") "

    The trick was using TEXT!

    Thanks again!

+ 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] Iterative Calculation
    By josephteh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-09-2016, 06:04 AM
  2. [SOLVED] Help with an Iterative Calculation
    By KDF in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2015, 02:34 PM
  3. [SOLVED] Iterative Backwards Calculation
    By bgerald in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2014, 01:43 PM
  4. Iterative calculation. What cells are processed first?
    By UML in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-11-2014, 05:17 PM
  5. How to siphon value away from an iterative calculation?
    By Sayle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2014, 09:47 AM
  6. Automatically enable iterative calculation
    By deucejmp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2011, 10:48 AM
  7. Iterative Calculation Issues
    By STarloff in forum Excel General
    Replies: 0
    Last Post: 06-08-2011, 12:15 PM

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