Get instant live expert help on I need help with excel if negative then zero

“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

I have a condition where the results of the excel (if and) formula count are negative and logically if the result is negative then zero (0) example: in the AA column the formula is = IF (AND (N19> K19, N19> AB19), Z19 * 1, N19-K19) if AA19 <0 (negative) then the result is 0 or AA19 * 1 how about the excel formula for the condition? thank you
Solved by M. S. in 16 mins
1. Subtract N2-I2, but if column I is blank, then subtract N2-G2 2. If the value of the above is a negative number, then set value to zero
Solved by X. W. in 13 mins
i need to write an if formula, turning all negative values into zero
Solved by G. H. in 15 mins
A formula if column D - E is negative becomes zero. If it's positive, do not change.
Solved by D. D. in 30 mins
Working on excel where i want to add a number to a column if the sum of that column is negative, to make it either zero or 10,000
Solved by E. E. in 25 mins