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
how do you absolute assign a row on an excel spreadsheet? Please advise. Thanks Janice
Solved by D. F. in 16 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?