Cells containing values not less than zero
=IF(A4-A50,A4-A5,0)
"Andrea" wrote:
Is there a formula I can include in an IF statement that would require the
number to be a positive figure. Or is it easier than that and I can format
the cell to equal zero or greater. For example, if my formula wants to
subtract cell A5 from A4, but but if A5 is larger than A4, 0 would be the
answer.
Thanks.
--
Andrea
|