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.
Excel 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.
Alternate 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.
Pivot 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..
Formula 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, DurkSlope 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!Excel - 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?
