Get instant live expert help on I need help with absolute value of a negative number

“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

FOR AM37, I want to count the number of negative consecutive numbers in AH excluding cells that no value.
Solved by C. U. in 18 mins
I have a series of number , I want to show if there is a positive number then 0 else add the negative number to the positive number till i get total negative number , basicaly showing what is due
Solved by A. D. in 22 mins
I have a numerical value in a cell. I want to make a formula that shows if the number in cell is greater than 0 then I want the answer to be that number. But if the number is less than 0 (a negative number) Iwant the number(answer) to be the value of the cell less 20%
Solved by I. J. in 14 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
How to i prevent the value from going negative. If it goes negative, it automatically set to 0
Solved by C. J. in 11 mins