AboutPricing

Get instant live expert help on I need help with absolute value example

“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.
< Go Back

    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
    I need a formula that adds a column example c5:c7 and then divides by an absolute like c4
    Solved by C. E. in 16 mins
    I need a formula that will let me copy a column into another column using an absolute reference from a third Column. Example being "Duplicate column I in column J using an absolute reference for Column H"
    Solved by F. L. in 16 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