K
kleivakat
I'm trying to put a formula in the cell that runs a formula, and if hte
result is less than zero, enter zero; if the result is not less than zero,
enter the result. Here's what I have so far:
=IF(+J2-I2<0,"0","=SUM(J2-I2)")
The first part works, i.e., if the number is less than zero a zero appears,
but the second part doesn't report the result if the number is greater than
zero.
Thanks for any help.
result is less than zero, enter zero; if the result is not less than zero,
enter the result. Here's what I have so far:
=IF(+J2-I2<0,"0","=SUM(J2-I2)")
The first part works, i.e., if the number is less than zero a zero appears,
but the second part doesn't report the result if the number is greater than
zero.
Thanks for any help.