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