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

Enter a function in cell E12, based on the payment and loan details, that calculates the amount of principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.

Solved by M. A. in 26 mins

Enter a function in cell G12, based on the payment and loan details, that calculates excel cumulative sum of interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.

Solved by B. J. in 13 mins

Enter a function in cell H12, based on the payment and loan details, that calculates the amount of cumulative principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Enter a reference to the remaining balance of payment 1 in cell B13. Use the fill handle to copy the functions created in the prior steps down to complete the amortization table.

Solved by S. Q. in 25 mins

enter a formula in cell C4 that divides the value in cell B4 by the value in cell B12, using an abs function cell B12

Solved by G. Y. in 22 mins

Hi! I need help with a complex "if" formula for cell C15 of the attached file using absolute value calculator:
If the absolute value of C3 is less than or equal to 100, then C3*(45/100)
If the absolute value of C3 is between 100.001 and 1000, then C3*(45/500)
If the absolute value of C3 is greater than 1000, then 90

Solved by F. L. in 14 mins

I need a formula that will let me copy a column into another column using an absolute reference from a third Column. Example being "Duplicate column I in column J using an absolute reference for Column H"

Solved by F. L. in 16 mins

Switch to the 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 S. C. in 11 mins

I created multiple formulas for concatenating cells. I want to use an if statement to say if the cell says x use this formula. I can't get it to bring back the formula. Is there something special that I should be doing? Also why do my formula's keep changing when I put a $ in front of the column. If I cut and past it changes the column that should be an absolute.

Solved by F. W. in 18 mins

I am trying to create formulas off of pivot tables and and using abs formula in excel, is there a workaround to be able to drag a formula down and have the data translate to each row?

Solved by O. E. in 26 mins

I have an Excel assignment that deals with various topics such as absolute cell reference and things like that. Can you show me absolute value examples?

Solved by S. U. in 11 mins