absolute value

I am trying to drag a formula across many columns, while maintaining the first two cells. However, I am having a problem locking the first two cells because once I select the range, it automatically adds the brackets for a Table, and I don’t know how to add a locked $ to that ($C$2:$C$100...

Hi Everyone, I've been developing a project for work that will analyse bank accounts to determine the value of a project. The problem is some of our projects have inter-account transactions. In order to determine the proper worth of the project we have to find any transfers between the...

Hello all, I have a problem that probably has a simpler answer than I realize, but I have been scratching my head all day over it. So I have a row of numbers, Say R10:AD10, that has lots of zeros and occasional positive and negative numbers in it. Sometimes this row will have a positive...

Hello ~ Can someone assist in helping me with correct formula. 1. I have 12 sheets (Jan, Feb, Mar, etc...) 2. I have a master sheet to "recap" the 12 sheets. 3. I have the first formula to read " =JAN!E49 (which means I am pulling information from Jan sheet from cell E49) Now, I want to copy...

I'm trying to creat a formula that states. If tank 1 maximum capacity is less than 500,000 and the difference in inventory is greater than the absolute value of 10% or 20,000 or if the tanks maximum capacity is between 500,000 and 1,000,000 and the difference in inventory is greater than the...

Hi there, I have a pivot table that shows the variance between actual results and their targets. Some of the variances are negative and some are postive. I want to have a PivotChart that shows the highest values, while keeping the sign. I have created a cell that contains the absolute value...

Hi, I'm working on Excel 2003. I need to find the average of the absolute values of values in column H only if column C contains the word "Correction" I tried doing AVERAGEIF(ABS(C2:C90, "=CORRECTION", H2:H90) but I'm probably way off. Thanks in advance!

Hi All, I am really struggling with the following formula: MATCH(MIN(ABS(Ann_TaylorRegularBust-B4)),ABS(Ann_TaylorRegularBust-B4),0) I am trying to find the cell in the named row "Ann_TaylorRegularBust" that is closest to the input bust size in cell B4. This formula works when I use actual...

I have a pivot table where I have entered a calculated field with Absolute Value: ABS(Forecast-Actual) The totals on each line are good but the grand total ignores the absolute value and sums the entire column as if it was not ABS. Example: <TABLE style="WIDTH: 147pt; BORDER-COLLAPSE...

Hello, thanks in advance for help. (using Excel 2007) I want to sum all the values in a column that fall within a certain range of that column's absolute value. The absolute value range is the criteria; however, I would like resultant sum to be based on the actual numbers not the absolute...