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!
Bookmarks