“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

how do you absolute assign a row on an excel spreadsheet? Please advise. Thanks Janice

Solved by D. F. in 16 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

I have an Excel assignment that deals with various topics such as absolute cell reference and things like that. Can you show me absolute value examples?

Solved by S. U. in 11 mins