Thread
:
Set negative numbers to zero. Do not calculate with negative valu
View Single Post
#
4
Posted to microsoft.public.excel.misc
Bob Phillips
external usenet poster
Posts: 10,593
Set negative numbers to zero. Do not calculate with negative valu
Depends upon your formulae. Post them.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Excel Headache" <Excel
wrote in message
...
I am working with fomulas that have diminishing values. I want the
dimishing
values to stop at zero (not turn negative). Problem is, I'm getting
negative
values that invalidate my data. Anyway way to "zero out" negative
numbers?
Reply With Quote
Bob Phillips
View Public Profile
Find all posts by Bob Phillips