H
Habanero
Any ideas how to force a negative number to display as
zero?
zero?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
General;"0"
A
Andy B
Habanero
A couple of ways:
Use a custom format.
Enclose your formula in a MAX function:
=MAX(yourformula,0)
Andy.
A couple of ways:
Use a custom format.
Enclose your formula in a MAX function:
=MAX(yourformula,0)
Andy.
H
Habanero
Thanks so much!!
-----Original Message-----
General;"0"
--
Regards,
Peo Sjoblom
.
G
Guest
Use the function +Max(0,.....)
J
J.E. McGimpsey
If you just want it to display as zero:
Format/Cells/Number/Custom General;"0";0;@
Format/Cells/Number/Custom General;"0";0;@