Get instant live expert help on I need help with excel absolute value 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

On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references.
Solved by S. S. in 30 mins
Need help with how to use if function in excel 2016 that requires absolute referencing
Solved by D. J. in 29 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
In cell B3, create a formula to retrieve the item within each category in cell B1. Enter an INDIRECT function to return the item numbers by category. The function will reference cell $B$1 (absolute) and index the value of the intersection of row 3 (A3) and column 1. Nest the function in an IFERROR function to return a blank cell if no items exist within the category.
Solved by S. H. in 18 mins
Use the VLOOKUP function in cell G11 to determine the insurance cost. Use the “Value” in cell E11 to lookup the appropriate cost on the "Insurance Cost" reference table (range K11:L18). Make sure to use relative and absolute references appropriately
Solved by I. D. in 27 mins