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

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