Get instant live expert help on I need help with excel absolute value multiple cells

“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 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
I need to input a value to multiple cells if a value is false
Solved by Z. Q. in 22 mins
I want to format cells so that when a certain value is entered multiple cells change colour
Solved by B. U. in 27 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 to use an excel if statement. I need to evaluate a cells value and see if it is above a value calculated in excel or not. If it is below a value then the value to be returned is the result of a simple formula involving multiple cell values. If the value of the cell is above that value then I need to apply a more involved formula using multiple cell values. Can an if statement do that?
Solved by A. D. in 22 mins