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!”
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