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!”
Here are some problems that our users have asked and received explanations on
I need to be able to copy this formula (=SUMIFS(data!$E:$E,data!$C:$C, $A$3, data!$A:$A, $A$1, data!$H:$H, $D$2)) to multiple cells while the last absolute value increases by 1 column to make it absolute for the new cell.
Solved by T. U. in 22 mins
Need help with copy a formula of 2 cells (F5 TO F6). Then use absolute references to copy the formula into cell G4 to calculate Percent of Total Sales.
Solved by I. H. in 13 mins
how to find absolute value? I need to find absolute value with a formula I copied. I need to copy the formula into cell G4.
Solved by I. E. in 12 mins
Conditional formatting across a column
Y6>=$C$2 Format J6
I've tried relative and absolute referencing to the cells and used format painter to copy down column J but it all formats when it shouldn't, same when using colum referencing rther than cell.
So checking if a date cell is greater than or equal to a date in cell C2 and if it is to change the format of cell in column J. Should I be doing this a different way?
Solved by F. Q. in 16 mins
I am trying to link the information from one sheet to the next within the same workbook. I know how to do all of the link methods, however, I want the data on the next spreadsheet to change and it is not. What am I missing here. I also did the absolute value of the column so the row would change. Please advise. I have attached the file.
Solved by X. Y. in 20 mins
Enter a conditional function in cell M3 to calculate average satisfaction of service for store 251. Format the results with the Number Format with two decimal points and Use the fill handle in cell M3 to copy the function down to complete the calculations. Be sure to use the appropriate mixed or absolute referencing.
Solved by X. C. in 11 mins
In column E, enter formulas that calculate the percentage of the grand total for
each type of school supply (total cost of each item divided by the grand total). Your
formulas must use appropriate absolute cell references. Format the calculated
values as Percentage with 0 decimal places.
11. In cell E16, enter a formula that uses a function to calculate the total of the column
(it should total 100%).
12. Repeat the process you used in steps 7–11 to calculate values for October. I came up with the right formula but when I push enter it goes to 0% instead.
Solved by B. B. in 27 mins
How to calcylate interest rate. I'm trying to figure out a interest rate over 10 years at 7% and initial investment of 5000.... cant seem to get the absolute formula to work
Solved by A. E. in 24 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 T. A. in 12 mins
What is absolute value? How to do it? when i try it makes it a P or doesnt do anything
Solved by B. B. in 23 mins