Negative result gives #### is there a way to show the actual - num
Post the formula and a description of the data the formula is manipulatiing
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"catts22" wrote:
Hi
The result of a formula gives me ##### for a negative number. Is there a
way to get the actual negative number (i.e. for example -9 instead of ###)?
Alternatively maybe show a 0 (zero)? Sending a report to my boss with ####
doesn't look so great. Maybe a minimum number formula?
Thanks
|