# Get instant live Excel expert help with ABS Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I've got absolute values in my pivot table and graph, how to use abs function in excel? I want to know the percentages for every row and put them in my graph. For example: in the first row, there are 96 times "gij/ge", 31 times "uTT", 5 times "uST" and 3 times "jij/je/jou". The total of the row would be 135. That means that "gij/ge" stands for about 70% of the row (96/135). I'm able to calculate the percentages for every column, since i got the grand totals per column (values --> show values as "% of grand total"). If I try "values --> show values as % of row total", I'm not getting the right percentages.
Solved by C. J. in 12 mins
got absolute values in my pivot table and graph as you can see in the picture. I want to know the percentages for every row and put them in my graph. for example: in the first row, there are 96 times "gij/ge", 31 times "uTT", 5 times "uST" and 3 times "jij/je/jou". The total of the row would be 135. That means that "gij/ge" stands for about 70% of the row (96/135). I'm able to calculate the percentages for every column, since i got the grand totals per column (values --> show values as "% of grand total"). If I try "values --> show values as % of row total", I'm not getting the right percentages.
Solved by T. W. in 29 mins
11. Enter a formula in cell E4 to calculate how long each item has been on sale. This is calculated by subtracting the launch date in cell D4 from the Data Updated date in cell C20. To show the time in years, divide that result by 365. Use an absolute reference to the date in cell C20. Copy the formula from cell E4 to cells E5:E14.
Solved by E. B. in 12 mins
On the Sales worksheet, enter a nested function in cell J8 of the Bonus column to display the bonus amount. If the employee sold \$200,000 or more (cell J2) AND is International (cell I4), he or she earns a 5% (cell J4) bonus on his or her total annual sales; otherwise, the representative earns 3% (cell J3) of his or her total annual sales. Use relative and mixed (or absolute) references correctly in the nested function. Copy the function from J8 to the range J9:J20
Solved by K. Y. in 24 mins
How to switch between tabs in excel? Choose worksheet “Internet user and pop. Table”. Use a VLOOKUP function in cell F2 so that it searches for the country in A2 (of current worksheet) that also appears within the “2016” worksheet and display its number of internet users. Expand the formula down to find the number of internet users for each country. (Be sure to use relative and absolute cell references as needed.)
Solved by C. S. in 26 mins
The question is- ''find the absolute max calculator errors for each participant when given the jar with 400 jelly beans and the one with 4466 beans. Present the scatterplot for these two errors and calculate their correlation. To what extent does this show that some people are consistently better at this task than others?'' The absolute errors have been calculated already, but I need help with the scatterplot and the last question as well.
Solved by E. H. in 15 mins
the question- Present the scatterplot from the absolute errors of the jars with 400 jelly beans and the one with 4466 beans and calculate their correlation
Solved by K. A. in 26 mins
I need a way to copy a formula across a row but reference cells moving down a column in another sheet. I used absolute cell references to keep the column consistent but I still have to manually adjust the formulas when I copy them across the row.
Solved by F. W. in 23 mins
I am trying to copy formulas I made with financial functions and I am using excel formula absolute value but when I paste it still uses the original formula for her first cell.
Solved by K. Y. in 13 mins
Sorry I'm an absolute noob in Excel, and actually need help with conditional formatting in Google sheets.I know it's not even half as good as Excel, but that's all I got to work with. I need to create conditional formatting: if the currency value in column B row 12 equals the currency value in column F row 12 then make the cells in columns A and B row 13 should turn green. I also want to ensure that should the rows change (i.e. I add or remove a row) the formula will still work.
Solved by S. B. in 16 mins