Cells containing values not less than zero
 

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

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

Cells containing values not less than zero
 

Another idea ..
=MAX(A4-A5,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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