Neative Formula
Try this:
=Max(0,A1-B1)
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"jen" wrote in message
...
Hope this is easy (for you). Haven't used excel in a long time and need to
create simple formula and can't figure it out.
Example: I want to show value as zero if addition comes out negative.
12000.00 -10000.00 = (2000.00) but I want the value to be zero not the
negative value.
|