Forum Widgets
Latest Discussions
Amortization Help
So I made a quick simple Amortization calculator to speed up some processes that I do but I've found so small calculation errors. For instance if I wanted it to calculated $7,268.00 over a 24mo term it come up with a payment of $302.83, which is correct, but because the actual payment amount is $302.83333333333 it doesn't calculated the right last payment which should be $302.91 to account for the repeating 3. I've found this is the only time it calculates wrong is just when the payment isn't perfectly round. Is there anyway to fix this? Again the only time I've found it to be wrong is when the payment doesn't calculate out perfectly round.SamM750Mar 17, 2025Copper Contributor5Views0likes1CommentExcel lookup help
Hi, I am trying to work out the formula in excel to look at a column (C12:C23) and if there is the same text more than once only return it once (A15). Then repeat this in A16 but disregard the value that was already returned already in A15 so it doesn't keep repeating. I have a list of descriptions that can be selected via a drop down list (image below C12:C23) and I need to bring them over to another sheet but not double them up if the description has been used more than once. It just keep doubling up. How can I do this? Thanks for any help with this.SolvedRichardLMar 17, 2025Copper Contributor61Views0likes3CommentsI need help setting up a cost / inventory lookup!
I started a sheet to do my inventory and cost association and was able to use the vlookup function to pull the name associated with the item number but not the cost over from a second sheet. Help!!!!!!LepardessMar 17, 2025Occasional Reader12Views0likes2CommentsAlternate to SUMIFS array assistance
Hello, everyone. I apologize for asking yet another SUMIFS question, but I haven't been able to find a thread anywhere (so far) that offers a sample similar to what I'm trying to do. I have a spreadsheet with 3 tables located in separate sheets: SKU, Production, and Expected. In the SKU table I have a list of item codes that are part of a general Category. In the Production table, I pretty much have a manual log of the number of Units that I produced in different Dates for each Item Code that applies. In the final table I pretty much just have a table with the Dates. The file I uploaded has a total of 4 columns in this table, but in my actual document the last 3 columns are actually arrays. I just placed them inside the table for purposes of this example. Anyhow, columns B-D are the Categories each Item Code belongs to: Blue, Green, or Red. What I'm trying to do is as follows: I'm trying to do the equivalent of a SUMIFs formula for Blue, Green, and Red. It first checks that the date in the Expected sheet matches the date in the Production sheet. Next, it checks in the SKU table which Category the Item Code belongs to for the selected date. It then adds the total Units for each Category column. I've tried with variations found online of SUMIFs and SUMPRODUCT, but I haven't been able to make them work. Any and all help is greatly appreciated.Eng_NoahMar 17, 2025Copper Contributor174Views0likes12CommentsPivot Tables
Hello all, For some reason, I cannot create PIVOT tables anymore, and I am not sure why. I am using the online version of Excel, on Microsoft Edge. When trying to pivot my data, it will with show up blank, or not at all. Does anyone know how to fix this issue? Please see attached photos..cnunezMar 17, 2025Copper Contributor33Views0likes2CommentsFormula doesn't "read" 0 as a number
Hello, I have a document what I get from my customer with lots of data, and need this to implement to our system, but I need only a few columns. The template is everytime the same. So, I made a new sheet, with a "output" and a "input" tab. I copy the whole document I get from the customer in the "input" tab, and in the "output" tab, I take the needed data with formulas. Now I have a column named "weigth". This is also in the document from the customer, but it is not converted to a number. When the number is 0("zero"), I have to leave it in my output-document blanc. I use this formula: =ALS(invoer!T=0; "";invoer!T2) But when the number is "zero", I get the number "zero" back, and it would not be leaving empty. When I enter a weigth in the input, like 15, I get in the output tab also the output 15. So, it works. Only not with a number "zero". When I convert the column to "number" in the Input-tab, it works also. Is there some work-around to make this work, without everytime converting the columns in the Input-tab? As of example I post a part of the input-document. I have to take weigths from several columns, in this sample it is column T. The output: I tried already to set the column as a "number", but everytime when I paste new data, it is overruled and fails again. Thanks a lot for help with this. Regards, DurkDurkHoutsmaMar 17, 2025Occasional Reader17Views0likes1Comment- Guus_1905Mar 17, 2025Copper Contributor16Views0likes1Comment
Slope equation calculation (Is it the same as trendline?)
Hi there, I'm trying to calibrate a temperature monitoring system in reference to a calibrated one. The relation is not linear, so the difference equation is not linear. This is where Excel comes in handy. I stuck both in water in the same environment at the same sampling frequency and generated a lot of points at a large temperature scale. Using a scatter chart, I generated a 4th-degree polynomial trendline that describes the relation between the both, with R2=0.9998. However, when using the equation to convert one value of one device to the equivalent in the other, the trendline equation throws random numbers at me, which makes me think that the trendline eq. and the slope eq. are not the same. I can share my date with anyone who is interested. Any idea on where I went wrong? Thanks!theDeCoder01Mar 17, 2025Occasional Reader22Views0likes2CommentsExcel - where is the default setting NEVER to wrap text?
Office21 Win11 I have a large spreadsheet - so all the columns are kept short to fit the width on my (wide) screen. A couple of the columns contain long paragraphs of text which can be edited only in the editing box. When I click on a paragraph cell, Excel wraps the text into a box about 15 characters wide and 30 deep, which means that I cannot see the adjacent cells. I have tried in the alignment tool to set the cell, column, the row, or the sheet to not wrap. But this is completely ignored when I next click on the cell. How can I set the default setting for the sheet never to wrap the text, under any circumstances, no matter what Bill Gates thinks would be better for me?Manchester05Mar 17, 2025Copper Contributor11Views0likes1Comment
Resources
Tags
- excel42,397 Topics
- Formulas and Functions24,583 Topics
- Macros and VBA6,375 Topics
- office 3655,980 Topics
- Excel on Mac2,633 Topics
- BI & Data Analysis2,352 Topics
- Excel for web1,901 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,619 Topics