Get instant live expert help on I need help with excel if negative
“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
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