# Get instant live expert help on find the absolute value

“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

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
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
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
=>Instructions: Apply the defined names Friday_TO, Sunday_TO, and Sunday_Pre to the existing formulas on the Ticket Sales worksheet. Ignore Relative/Absolute value and use row and column names. (Hint: If you receive an error that Excel cannot find any references to replace, make sure that only a single cell, rather than a range, in the worksheet is selected prior to applying the defined names.) -- Im trying this and keep seeing the error that it cannot find any references to replace.
Solved by B. F. in 18 mins
i need help with a formula that allows me to find the same value in another workbook then enter another value from the row it find the match. i know vlookup allows me to find the match but i dont know how to get the other value after it find the match.
Solved by B. H. in 30 mins