 # 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