calculation

I have developed nested IF formula that works fine but I have to use it in 44835 cells that makes my Excel file 4,8 Mb in size and worksheet pretty slow on i5 Intel with 8 Gb of ram. Is there any way to rewrite formula to make it more efficient or maybe do something else to speed up my program...

I would like to add an additional row in my pivot table for percent of Gross Sales below each of the following categories. Any idea if this can achieved? Gross Sales POD Expense Commissions Rebate Discount Freight Costs Net Sales $4,69,655 $293,212...

I currently have a calculation that takes the start date, adds the duration of days and calculates the finish date excluding holidays and weekends. I would like it to do the opposite. Take the finish date, add the duration and back into the start date. excluding Holidays and weeds Any help would...

I need help please, I have various conditions and got this far =IF(AND(W687>0;X686>0);(W687*Y687*G687)+X686*Y687*G687;0) only problem is that if cell W687 is negative it should still perform the calculation for X686 if this cell is positive. How can I change the formula to do this. Thank...

Hello there, I have the following formula: =SQRT(SUM($N$2:$N2)/SUM($G$2:$G2)) Column 'N' refers to a simple calculation: = B2*B2*G2 Can anyone supply a simple method of combining the calculation in column 'N' directly into the original formula? Thanks in advance, B.

Iam trying to create VBA code to compare the values in a single column andperform a calculation if the condition exist. The below table is a sample of mydata. The 1st 5 numbers of the Security is always a unique number and alwaysend with US. The difference is some lines end with an L (meaning...

Hello - I calculate the difference between the last cell in a column and the first cell in a column. The first cell in the column is an absolute value ($A$1), but the last cell in the column changes daily and the last cell changes daily. For example, today the calculation is A25-$A$1, but...

Thanks in advance for the help. The calculation sheet has several API keys that determine distances between multiple start points compared to one end point. The data dump sheet list all my end points that I want to know the optimum distance. Instead of manually going line by line, I would like...

I need to do a simple addition of column containing times. The cells are formatted [hh]:mm so no problem going over 24 hours. However calculation is out by a few minutes (total shows 91:09 but should be 91:15). I have checked that there are no random seconds in any cell. Just doesn't make...

Good morning, I am using average if =AVERAGEIF(AT177:AY177,"<>0"), to get the average of a series of data (similar to the one in the fist raw I have pasted here) I am using if because I need to exclude the "0" from the calculation. The complicated things for me now is that I need to divide each...

Can you use a selection in a filter for a pivot table ie ALL and use an if() to do a calculation depending on filter value?

ok folks ... I'm grasping at straws here. A couple of times recently a colleague has had a problem that I have resolved as being caused by the formula calculation option being set to Manual .... it wasn't too much of an issue because I knew when she called what the problem was. However the issue...

Hi All I am working with 2 sheets. Sheet 1 is manual calculation and on deactivate, it calculates sheet 2. Sheet 2 has code to autofilter the sheet. The problem is that when I open sheet 2, the filter macro runs before the calculation finishes that is triggered when I leave sheet 1. I have to...

I'm wondering if it is possible to have a dynamic percent change calculation done? I have values from last year and values that will populate for the current year throughout the year. Is it possible to to have a formula look at how many cells are populated in a range and then make a calculation...

Hi Guys, I wonder if anyone can help. Instead of using the below formula "=COUNTIFS($A$1:$A3,$A3,$B$1:$B3,$B3)" where the 3 does not have a dollar so that the range can expand. Is there a way to do the same calculation but within a table? The above formula is ok but if you sort the data it...

Hi guys, Can anyone help me out sorting this issue i have? What i'm trying to is to get a formula that makes a calculation for all the previous months (this year and the previous ones). For the current month (and following months) the cell value will always be "". I've come up with this but...

Hi all, I can't find the answer to this so hoping someone can tell me how. In a nutshell, I need to use the result from one column (month) as the starting point of the next column's (month's) calculation. As in, a rolling subtotal of activity from one month to the next. I cant find how to...

In cells A10 and C10, I have two different calculations with a number total for each cell. In B10, I'd like to have a calculation that looks at A10 and C10 . . . if those two numbers are the same or within 1 of each other, B10 is bright yellow. If A10 and C10 are different by more than 1, B10...

Hello This is something that has happened to me some times but never understood why. I'm doing a simple calculation which I can easily do in my head, and the answer should be 0 but excel returns a negative 0. Upon further inspection the 14th decimal position has a value, but it should be 0...

I have several spreadsheets that require the 'Enable Iterative Calculation' to be selected in order to work correctly. Our business calcs require circular calculations on almost every sheet. Once I have this option checked, it stays active but only for me. It does not stay checked for my...