“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

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

If B2-A2 is negative converts it to positive, if it is positive puts 0

Solved by Z. J. in 16 mins

How to calculate the negative error value of standard deviation and positive negative error value of Standard Deviations Wanted to check if the graph is correct>>

Solved by E. E. in 13 mins

i need to write an if formula, turning all negative values into zero

Solved by G. H. in 15 mins