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