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

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