display negative numbers as zero
maybe...
=if(a4a5, a2, max(0,a4-a2))
Andrea wrote:
can i display a negative number as a zero?
thus if my formula reads: if(a4a5, a2, a4-a2) but a4-a2 cannot equal a
negative number? lowest it can be is zero. this formula appears on multiple
workbooks, thus it cannot just be if(a4a5, a2,0).
thnaks.
--
Andrea
--
Dave Peterson
|